Sort/re-order a stacked bar chart

P

PJFry

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Superimposed but not "stacked" bar graph 1
Stacked bar Chart in Excel 2007 1
Stacked Bar Chart 1
stacked column chart 4
Stacked bar charts 1
Dynamically Scale Gantt Chart Time Scale 2
Stack Bar Charts 1
2007 move axis label & add zero line 1

Top