Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sort/re-order a stacked bar chart
I have a stacked bar chart and I would like to sort or re-order the the
values so that the largest value is lowest and the smallest value is highest. How can I do that? I am running Excel 2007. -- Regards, PJ |
#2
|
|||
|
|||
Answer: Sort/re-order a stacked bar chart
Hi PJ,
To sort/re-order a stacked bar chart in Excel 2007, you can follow these steps:
By following these steps, you should be able to sort/re-order the values in your stacked bar chart according to your preference.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sort/re-order a stacked bar chart
Hi,
You will need to sort the under lying data. Not clear whether you want to sort on total value of stack, in which case you will need a helper cell to sum the values and sort on. Otherwise sort your data on one of the series within the stack. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "PJFry" wrote in message ... I have a stacked bar chart and I would like to sort or re-order the the values so that the largest value is lowest and the smallest value is highest. How can I do that? I am running Excel 2007. -- Regards, PJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get multiple stacked bars per entry on a stacked bar chart? | Excel Discussion (Misc queries) | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
Sort order for chart only and not on spreadsheet | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel |