How do I sort the columns in an Excel chart ?

Hi,
Is it possible to sort a simple vertical column chart so the columns appear in descending order of value from left to right ?
Or do I have to sort the source data first ?
Thanks
Toco
TocogroupAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
Or you can create a second serie bound to the original serie and build the chart from there. Here's an example on how you could build a sorted list from your original data:

http://excel-user.blogspot.com/2011/02/large-functionget-top-n-values-from.html

jppinto
0
 
jppintoCommented:
The simplest way is to sort the source...
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

Excel plots the data in the order that it appears on your sheet. You can not re-arrange the columns in the chart.

So, either sort your data or chart off a separate helper range where a sorted copy of your data lives. If you want the sort to be dynamic, Jppinto's suggestion will come in handy.

Cheers, teylyn
0
 
TocogroupAuthor Commented:
Very good. That's really useful and easy to follow too.
many thanks
Toco
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.