Solved

How do I sort the columns in an Excel chart ?

Posted on 2011-02-28
4
235 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:Tocogroup
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 35001870
The simplest way is to sort the source...
0
 
LVL 33

Accepted Solution

by:
jppinto earned 500 total points
ID: 35001889
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
 
LVL 50
ID: 35001975
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
 

Author Closing Comment

by:Tocogroup
ID: 35001990
Very good. That's really useful and easy to follow too.
many thanks
Toco
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel VBA inserting a formula 12 39
Excel to show a dynamic Picklist at level2 2 23
Excel Auto-Complete lines 4 32
WIthin VBA summing record count in 3 tabs 7 39
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question