sorting data for multiple charts

[danlightbulb]

Ok guys this might be a simple one for you:

I have a set of data in an excel spreadsheet. I want to make a number of charts from the same data, but each chart requires the data to be sorted in a different way.

So far I cannot find a way to do this other than copying the data table to another sheet, sorting and then graphing. That way its one set of data per graph which means that when I change anything I have to recopy all the data to the other sheets.

Any comments appreciated.

[MrShorty]

Not a lot of detail, but I tried this, and it seemed to work:

sheet1 main data source sorted by column A in ascending order
1 d
2 c
3 b
4 g
7 a


sheet2 formula in a1=sheet1!a1 then copied over range. Then sorted by column A in descending order:
7 a
4 g
3 b
2 c
1 d

sheet3 formula in a1=sheet1!a1 then copied over range. Then sorted by column B in ascending order:
7 a
3 b
2 c
1 d
4 g

and so on. The spreadsheet keeps the links intact even after sorting. But if I go back and sort sheet1 differently, then I would need to resort sheet2 and 3. It's not entirely "automatic" but, upon entering new data in sheet1, you would simply need to resort each sheet. And each sheet "remembers" the sorting criteria, so all you need to do is alt-d/s/enter for each sheet. I did not play with the charting aspect, but I expect it could work correctly. If you need it to be more automatic, I'm sure that it could be programmed in VBA.

Does that help??

[danlightbulb]

Cheers, not knowing anything about VBA this seems to be the only option.

Cheers