| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart sort data issue | Charts and Charting in Excel | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| Dynamic column chart - auto sort on data range | Charts and Charting in Excel | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
| How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
Linear Mode
