Mar 9 2006, 11:17 AM
I am building a stacked bar chart in Excel and I am wondering how I can change the plot order on the chart itself ?
Any suggestions ??
Oxford, CT. USA.
Mar 9 2006, 11:19 AM
can help you!
Mar 9 2006, 11:22 AM
Thanks Freak but that's a regular chart with one series.
I have a chart with 4 separate series of data.
I was hoping for some kind of mechanism like in Access when you want to change the tab order in a form ?
You highlight a control and then click to move it up or down in order......??
Thank you though !
Mar 9 2006, 03:20 PM
the only thing you can do from the user interface (I think) is to change the series order (the order of the stacked points):
1) Select the series
2) Right-click : Selected Object
3) Series Order, Move Down/Move Up
Mar 9 2006, 03:42 PM
What version of Excel are you working in ?
I don't have those selections available to me ...
Mar 9 2006, 03:54 PM
I have XL 2003 but I think this works since XL97... not sure though.
Also, select series, Format=>Selected Data Series=>Series Order...
Mar 9 2006, 04:04 PM
Found it !!!!
Thanks Martin for your help....why couldn't I find that before ??
Mar 9 2006, 04:28 PM
Select any of the series, RIGHT-click, first item on the top
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here