Sort/re-order a stacked bar chart

  • Thread starter Thread starter PJFry
  • Start date Start date
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.
 
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

Stacked bar Chart in Excel 2007 1
Superimposed but not "stacked" bar graph 1
Stacked Bar Chart 1
Stack Bar Charts 1
Stacked bar charts 1
stacked column chart 4
Stacked column chart narrow bars wanted 5
Stacked bar chart with totals - Excel 2003 2

Back
Top