If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|