sorting columns in a charts
 

I have data in 5 columns, 20 rows. Column A is salesman, Columns B-E are
things like sales quota, monthly sales, salray, etc.

If I sort Column B and then create a chart using columns A and B my chart
will show the columns in order of least to greatest value. But then if I
create a chart using columns A and C the columns will be in the order I
sorted column B. If I sort column C, my chart with column B is no longer
sorted. How can I make 4 charts on one printed page with these 5 columns
and ALL the charts be sorted by value?

sorting columns in a charts
 

Hi,

I doubt you can. You will need to have a column of names for each of the
sorts.
I assume you don't want the extra columns because the table is also part
of the report. If so you could always create the chart data on an area
of the sheet that is not printed. Or hide the columns making sure the
option to "plot visible cells only" is disabled (with chart selected use
Tools Options Chart).

Cheers
Andy


Some Dude wrote:
I have data in 5 columns, 20 rows. Column A is salesman, Columns B-E are
things like sales quota, monthly sales, salray, etc.

If I sort Column B and then create a chart using columns A and B my chart
will show the columns in order of least to greatest value. But then if I
create a chart using columns A and C the columns will be in the order I
sorted column B. If I sort column C, my chart with column B is no longer
sorted. How can I make 4 charts on one printed page with these 5 columns
and ALL the charts be sorted by value?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info