| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| Sorting on columns | Excel Worksheet Functions | |||
| Sorting a row....instead of columns | Excel Discussion (Misc queries) | |||
| Sorting two columns | Excel Worksheet Functions | |||
| Sorting Bar Charts | Charts and Charting in Excel | |||
Threaded Mode
