View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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