I would like to create a chart that automatically sorts columns of numerical data from highest to lowest. The problem is that the sorce data is pulled from various cells across a report, so I can't sort the source data directly since the cells need to remain in their original locations to maintain the format of the report.

I created another area in the spreadsheet that has all the needed data in one location by referencing the original cells. But since only references to the original cells are stored there, and not the values themselves, the sort function does not seem to work correctly on this data (I'm guessing that's why it's not sorting correctly).

I could just copy the values over to this new area, but then I have to re-copy and re-sort the new values everytime the source data changes so that the chart remains updated and sorted. How can I get the chart to update and re-sort automatically everytime data in the original cells changed.

Any help would be appreciated. Thanks,

Steve