sorting columns in a charts

[Some Dude]

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]

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