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?
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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks