I would like to select the first chart in the sheet and set the min and max
values... the code says an object is not set... any help is appreciated!
Dim MinVal As Range
Dim MaxVal As Range

i need to put the numbers of all the sheets i have created onto one sheet
have this done automatically is there anyone out there that can do this

I'm new to creating charts in Excel, but I can't figure out how to do
this...
After I create a chart from a range of cells, can I hide the original
cells that contain the source data ?

is it somehow possible to manipulate the legend of a chart?
I would like to only show the first, say, four series in the legend of
a chart even if there are, say, seven series available. Is this

I have been playing with the attached chart's legend for some time now.
I have browsed about fifteen of the previous comments related to
changing the legend's order, implemented the changes, and none of them
have helped.  I would seriously appreciate anyone who would take a look

I was wondering if anyone could help me out with cointegration charts in Excel.
Thanks in advance.

Is it possible to plot Ternary (x vs y vs z) in Excel, like in Deltagraph ?

Excel 2003 Chart y-axis: how do I stop it truncating the text?
It used to be ok in Excel 2002!

I have data entered in 6500 cells, in size order, but only want to plot every
65th cell so as to build a representative distribution.
How can I instruct Excel to skip cells for graphing?
Thanks in advance,

Got error in this statement.
xlApp.Sheets(1).Shapes.AddShape(msoShapeRectangle, 60.75, 222.75, 6,
6).
Its working fine in Macro. I tried run this macro code using Visual

I created a line chart that plots a set of predetermined values, in this
case, a salesman's payout for hitting a certain % of his quota.  The %'s to
quota are along the x-axis and the payouts are representated on the y-axis.  
(Example: at 95% = $4,000, at 100% = $5,000, etc.)  ...

How do I plot a graph from an excel spreadsheet that shows the values of one
variable versus the values of a different variable, ie.  along the X-axis
weight in kg  ,  then along the Y-axis the % body fat ?

I have data collected on a daily basis (for work days) over several years,
and I want to plot it on an X-Y plot versus date. I would like the monthly
intervals showing on the scale to be like 1/1/04, 2/1/04, 3/1/04, etc.
Similarly, for annual intervals, 1/1/03, 1/1/04, 1/1/05, ...

I'm plotting monthly and ytd data as columns on the x axis.  And for the y
axis, I'm showing a percentage that relates to the monthly data, not the ytd
data.  I've formatted the 4 sets of columns to "0 overlap" and "100 gap
width".  So, for each set of columns (month and ytd), ...

I'm using Excel 2002 (and a newbie) and want to add comments to different
points in a chart so I can clearly see when specific things changed and how
they effected my chart.
(I was referred by one to look at an add in program that can add data