Thread: Sort Chart Data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default 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