Sorting in Charts

  • Thread starter Thread starter Kelsey
  • Start date Start date
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??
 
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

Sorting PivotChart 1
Help, please: sorting the Legend 2
Chart Sort 8
Formatting Data point in Bar Chart 1
Display order of Bar Chart 2
Manual sort in a pivot chart/pivot table 5
Contact Sorting 2
record sorting 3

Back
Top