I'm using the stacked bar and column combination trick for one of my graphs but it doubles the number of items in my legend.  Is there any way that I can remove half of those items from the legend?  If not, are there any other creative ways of doing this
My last resort will be to ...

I have a chart that when I first graphed it automatically when to a value axis.  I need the axis to be a catagory axis.  Any suggestions on changing this.  The graph is fairly complex so I really don't want to regraph the file.

Is there an easy way to plot a 2-D contour chart?  I have data that
takes x1 and x2 as input and i want to show z in contours.
john

Is it possible to set the colour of a chart sheet (not the chart area o
plot area, which are both transparent) as something other than whit
without inserting a picture as a background (which is memory hungry fo
multiple chart sheets)

I am using excel to create a timeline to compare when
different people were born (and died) and when significant
events happened.  I have worked out how to do the births
and deaths part in a bar chart, but so far, the only way I

Hi people
I have 2 queries relating to Radar charts in Excel (Office XP/2002).
Can I change the angle/start position of the first plotted point? I
always starts at 12 o'clock but I want it to start at 9 o'clock. I ca

I am trying to add names to 3 charts, all in the same sheet
But this code is giving runtime error
Worksheets("Analysis").Activat
With ActiveShee

I would like to know how to create a data point line as a
point of reference for a column chart so that the data
for the previous year could be displayed as a line amidst
the columns. Thank you for your help.

I want to fit datapoint on a chart.
'Linear', polynomial are possible,
but 'power' and 'exponential' are gray
and not activated. How can I activate these

I would like to tell excel to export graphs I created in a
workbook, to a powerpoint presentation.  One graph per
specific page in ppt.  I would like that anytime I update
the excel document it automatically updates the graph in

I have a vb program that pulls data from a database and displays it
onscreen. This includes a chart - is there a quick way of bascially copying
this chart into an excel spreadsheet via code from my program? I have
already got my listboxes and so on to fill in their info onto a new ...

does anybody know how to put one data on the top of another in the
column type chart?
---
Message posted from http://www.ExcelForum.com/

I have added new data into a chart by using a MACRO. perhaps it is not
possible to undo this using edit-undo.  Is there any method to celar only
the added portion in the chart  If I click the chart and click<clear> the
whole chart is removed.

I'm trying to update a chart with more data. I choose
'source data', 'series' then 'values' and select the data i
want to add using the ctrl button but i'm not able to
select some of the cells in the worksheet. When i try to

Both machines are running the same version of Excel.  Yet,
when I view it on my machine, everything appears fine.  
When I go to another machine, the "Y" axis is cutting off
letters.  I thought it was a print-driver issue but it's