Good Morning,

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 ??

Thanks,

Joe
Oxford, CT. USA.

Hi,
maybe this can help you!
HTH
Good luck

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 !

J.

Hi Joe,

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

Martin

What version of Excel are you working in ?
I don't have those selections available to me ...

I have XL 2003 but I think this works since XL97... not sure though.

Also, select series, Format=>Selected Data Series=>Series Order...

Martin

Found it !!!!

Thanks Martin for your help....why couldn't I find that before ??

Joe

Select any of the series, RIGHT-click, first item on the top

You're welcome
martin