Thread: Sort column chart without sorting source data

Hallo

I'm still pretty new to charts and I was jsut wondering if it is possible to sort a chart somehow so that the data shows largest result in the left hand column down to smallest in the right hand without having to re-sort the source data

The reason I ask is that I have two sets of charts running off one table of data, one chart has to show sorted in cost and the other in numbers of reports

I have a rotten feeling it can't be done and that I will have to double up the table and sort each on for each set of charts, but I thought I'd ask you clever people before I gave in!

Many thanks in advance

R

Create a list in a column that references your results.
You could do this on a hidden worksheet or just color the numbers white (to hide)
Record a macro that sorts the reference column.
Now link the chart to the reference column.
Link the macro to a button, when you press the button it sorts

Hi Andy

Thanks for that - I ended up doing someting very similar, but decided to split the tables and then do the macro part

Many thanks though for answering - I had a feeling that excel didn't have an option within the chart for sorting

R