Sorting in Charts

K

Kelsey

Hi, is there any way to sort names in a table,
alphabetically, and then have numbers in a bargraph go in
descending order?
Okay, I have a table with a list of people's names and
then their averages. Now I want their names in
alphabetical order for my table. But, in my bargraph
containing their averages, I would like the bars to be in
descending order.
Is it possible to sort in two different ways??
 
J

Jon Peltier

The easiest way is to have two different tables: One sorted for tabular
output, the other for graphical output. They could be independent
tables, or you could use lookup functions to get the numerical sorting.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Help, please: sorting the Legend 2
Standard Error Formula 1
record sorting 3
Do not sort data alphabetically in a Pivot table 1
Contact Sorting 2
Display order of Bar Chart 2
Sorting in Excel 2
How Do I 'Lock' My Chart? 1

Top