I want to display data within a chart in descending order without sorting the data source spreadsheet. Is this possible? I am using a bar chart for example and would like to graph the Top 20 values in descending order within the chart. I don't want to disturb the data source spreadsheet and do not want to create any more sheets or cells. I am trying to keep the workbook size to a minimum for distribution sake. Any help you can offer would be great.
Thanks,
Waxaholic
Thanks,
Waxaholic