Legend on Chart
 

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?

Legend on Chart
 

Change the order of the series. Double click on one series, and go to the
Series Order tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" <Double wrote in message
...
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?

Legend on Chart
 

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.


"Jon Peltier" wrote:

Change the order of the series. Double click on one series, and go to the
Series Order tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" <Double wrote in message
...
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?

Legend on Chart
 

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" wrote in message
...
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.


"Jon Peltier" wrote:

Change the order of the series. Double click on one series, and go to the
Series Order tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" <Double wrote in message
...
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?

Legend on Chart
 

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!

"Jon Peltier" wrote:

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" wrote in message
...
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.


"Jon Peltier" wrote:

Change the order of the series. Double click on one series, and go to the
Series Order tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" <Double wrote in message
...
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?

Legend on Chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" wrote in message
...
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!

"Jon Peltier" wrote:

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" wrote in message
...
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.


"Jon Peltier" wrote:

Change the order of the series. Double click on one series, and go to
the
Series Order tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" <Double wrote in message
...
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?

Legend on Chart
 

How do you change the order if the series are not on the same axis? (two are
on the primary access, and one is on a secondary access)


"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" wrote in message
...
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!

"Jon Peltier" wrote:

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" wrote in message
...
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.


"Jon Peltier" wrote:

Change the order of the series. Double click on one series, and go to
the
Series Order tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" <Double wrote in message
...
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?

Legend on Chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JonO" wrote in message
...
How do you change the order if the series are not on the same axis? (two
are
on the primary access, and one is on a secondary access)


"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" wrote in message
...
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!

"Jon Peltier" wrote:

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" wrote in message
...
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.


"Jon Peltier" wrote:

Change the order of the series. Double click on one series, and go
to
the
Series Order tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Double L" <Double wrote in message
...
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?