| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| legend on the chart | Charts and Charting in Excel | |||
| Bar Chart Legend Key | Charts and Charting in Excel | |||
| Chart Legend | Charts and Charting in Excel | |||
| pie chart legend | Charts and Charting in Excel | |||
| Chart Legend | Charts and Charting in Excel | |||
Linear Mode
