Solved

How do I sort the columns in an Excel chart ?

Posted on 2011-02-28
4
236 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

623 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