Hi,
You can change the legend order to some degree by changing the Series
order. Double click a series and check the Series tab. You will have
problems if the chart types are different or you are using the secondary
axis.
You could do a find and replace on your data. Find whole cells
containing zero and replace with the function =NA()
Although I don't know how you tell the difference between zero's you
don't want and true zeros.
Cheers
Andy
Me wrote:
I have two Excel 2003 questions:
1) Is there any way to move a series of data once a chart has been created?
For instance, say my four series are listed in the legend as 2, 3, 4, 1, and
I want to put series 1 to the top. Is there an easier way than going back to
the source data and re-establishing all the data series in the order I want
them to appear in the legend?
2) I have a chart that automatically pulls its data source from another
worksheet to create a graph. The problem is that there is a lot of zero data
being pulled over, and this zero data is still being plotted into the graph.
Is there a way to have the graph only plot the data series' greater than
zero? Since I don't know VB, I'd prefer to know if this can be done via
conventional Excel functionality.
Thank you.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info