Graph Series Questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Ahh, perfect!

Thank you!

Andy Pope said:
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
Click to expand...
 
Back
Top