Sort Chart Data
 

I have the following source data for a stacked column bar chart. Each name
is a series and the dates are on the category axis. I'm trying to sort the
bars so that on the 30-Jun bar, for example, sam would be on top, the Peg,
etc. I've tried several suggestions on this site, to no avail. Can someone
help with my example? Thanks.

scott brian june peg sam
30-Jun 0 5 0 6 11
11-Jul 1 8 3 11 4
18-Jul 8 5 6 2 5

Sort Chart Data
 

Can't you sort the source data?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Alex" wrote:

I have the following source data for a stacked column bar chart. Each name
is a series and the dates are on the category axis. I'm trying to sort the
bars so that on the 30-Jun bar, for example, sam would be on top, the Peg,
etc. I've tried several suggestions on this site, to no avail. Can someone
help with my example? Thanks.

scott brian june peg sam
30-Jun 0 5 0 6 11
11-Jul 1 8 3 11 4
18-Jul 8 5 6 2 5

Sort Chart Data
 

Organize the columns left to right, such that the bars you want to appear
highest in the chart are furthest to the right. You can't mix the order of a
series in different stacks, in other words, the top series is on top of all
stacks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Alex" wrote in message
...
I have the following source data for a stacked column bar chart. Each name
is a series and the dates are on the category axis. I'm trying to sort
the
bars so that on the 30-Jun bar, for example, sam would be on top, the Peg,
etc. I've tried several suggestions on this site, to no avail. Can
someone
help with my example? Thanks.

scott brian june peg sam
30-Jun 0 5 0 6 11
11-Jul 1 8 3 11 4
18-Jul 8 5 6 2 5

Sort Chart Data
 

Thanks Jon - makes sense. No wonder I couldn't figure it out.

"Jon Peltier" wrote:

Organize the columns left to right, such that the bars you want to appear
highest in the chart are furthest to the right. You can't mix the order of a
series in different stacks, in other words, the top series is on top of all
stacks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Alex" wrote in message
...
I have the following source data for a stacked column bar chart. Each name
is a series and the dates are on the category axis. I'm trying to sort
the
bars so that on the 30-Jun bar, for example, sam would be on top, the Peg,
etc. I've tried several suggestions on this site, to no avail. Can
someone
help with my example? Thanks.

scott brian june peg sam
30-Jun 0 5 0 6 11
11-Jul 1 8 3 11 4
18-Jul 8 5 6 2 5