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/
_______
 
Back
Top