Legend on Chart

  • Thread starter Thread starter Double L
  • Start date Start date
D

Double L

I am updating chart that includes three years of data and want to add 2008.
The data has transferred, but the legend shows 2007,2008,2006. How can I get
2008,2007,2006 in order in the legend?
 
Change the order of the series. Double click on one series, and go to the
Series Order tab.

- Jon
 
Jon-

From the "Select Data Source" box, I entered 2008 as a new source and
removed 2005. I then moved 2008 ahead of 2007 on this list. I cannot
double-click on anything that brings up a Series Order tab. Can you advise?
Thank you for your help.
 
You didn't say you were using Excel 2007, so I went with the law of
averages. Excel 2007 has the move up and move down buttons, so the old
Series Order dialog is unnecessary.

Are the series still out of order after you rearranged them in the Select
Source Data dialog? Are they all the same chart type?

- Jon
 
Jon-

Sorry I didn't clarify that I was using Excel 2007 - that probably would
have helped!! Anyway, the series is still out of order even after I
rearranged them in the Select Source Data dialog and they are the same chart
type.

For some reason, I cannot put either year (2006 or 2008) in front of 2007.

I appreciate all of your help!
 
Look at each series' formula: when you select a series and look in the
formula bar, you'll see something like this:

=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$10,Sheet1!$B$2:$B$10,1)

The last argument, 1 in the above, is the plot order of the series. If all
the series are the same type and on the same axis (primary vs. secondary)
this dictates the order in which they are plotted in the chart and listed in
the legend.

- Jon
 
You can't. Chart series are listed in order, but all series on the primary
axis are listed together, separate from all series on the secondary axis.
Within the axis groupings, series of each type are also listed separately.

- Jon
 
Back
Top