Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change the order of the series in the Source Data?
I have a chart that trackes sales numbers by the month. Each year I add a
series. I would like to get the series to display in order. How do I change the order? |
#2
|
|||
|
|||
Select the series that you want to reorder. You will see something that
looks like this: =SERIES(,'Sheet1'!$A$2:$A$11,'Sheet1!$H$2:$H$11,5) You need to change the # at the very end of the series. =SERIES(,'Sheet1'!$A$2:$A$11,'Sheet1!$H$2:$H$11,1) "Earl" wrote in message ... I have a chart that trackes sales numbers by the month. Each year I add a series. I would like to get the series to display in order. How do I change the order? |
#3
|
|||
|
|||
Earl,
In addition to Barb's method you can also do this: Click on a series and in the standard toolbar select: Format - Selected Data Series - Series Order Tab Move Up or Move Down buttons ---- Regards, John Mansfield http://www.pdbook.com "Earl" wrote: I have a chart that trackes sales numbers by the month. Each year I add a series. I would like to get the series to display in order. How do I change the order? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change the data series an an excel graph | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
pivot table in data source order | Excel Discussion (Misc queries) | |||
Charting data ranges that change | Charts and Charting in Excel |