I am using Excell 2007.  Whenever I want to add a gradient to a color - for
example in a bar or pie chart - it shows me the types of gradients in a
stupid light blue color.  If I choose one it changes my color in the chart to
this color and does not apply the gradient to the ...

I have this macro below that creates charts automatically and it works
so far with no problems. I have 4 sheets Sheets("V","$","RU","Chart")
Currently all the charts gets created below the actual data sheet
"$".

Is it possible to have a trend line only look at a part the data?  Example
use only the last 30 entries or so.
Thanks
Chad

I have two data sets I am tracking against each other and I would like to be
able to display the delta between the two lines.
the high low lines would be great if you could add a delta number to them
but I don't think that is possible.  is there some other functionality that

Hey all,
I am having a very inconvinient problem, which seems to potentially ruin
several weeks of hard work -- and it would be immensly appreciated if anyone
could come up with a quicly implementable solution.

In Excel 2007, when I try to plot vertical error bars on a chart with no zero
or negative values it gives me the standard error that "Negative or zero
values cannot be plotted correctly on log charts." Then when it actually
graphs the data there are strange black triangles ...

I have a strange problem whereby I cannot move a newly created chart to a
new sheet. I am running Microsoft Office 2007 Professional edition.
What happens is, when I create a new chart, the chart comes up in the
current worksheet. When I try the move the chart (either by hitting ...

Should be a simple graph - but!!!
A typical plot that I just can't make work would be for the following simple
data for various aircraft:
X-Axis values (cruise speed - mph) - 315     325     355       520    and

I'm trying to get one bar line with two trends lines. I've tried using custom
type charts by selecting "Line-Column on 2 Axis". With selecting this chart,
it will have 2 bar lines and one trend line instead of what I need. I've
formatted both axis to fit the correct numbers. I ...

I would like to set the min and max values of the y axis on a scatter chart
to be the value of a cell.  Using excel 2003.

I'm sure this is a super simple question.  I just started testing some simple
charts in 2007.  I have a small grid with 4 years and 4 dollar values.  
(years are 2004, 2005, 2006, 2007).
I want to make a simple bar chart with the $ values on the Y axis and the

I want to make a new model of chart, i don´t no is or not possible.
I seed that in a company presentation, but maked it with two grups os value
and is very dificult to atualized.
Imagine the sample below with colums:

I have a worksheet that I use as my "main" worksheet that is linked to
several more worksheets where the information after calculations is
populated.(The other worksheets are 'read only' and emailed to others.) I
have been asked to graph the trends of several items in my main ...

I have a scatter graph from a series of labels with corresponding x/y values.
I want the labels to show up on the graph with each individual point. E.g.
Banana (5/9), Apple (4/10), Orange (2/3) etc. It should be very
straighforward! I have the list of labels in one column (Banana ...

Can you suggest a good book or website that details how to create charts such
as waterfall, bubble using 2007 version of excel?
Thanks