Results 1 to 2 of 2

Sort chart data descending without sorting data source

This is a discussion on Sort chart data descending without sorting data source within the Excel Questions forums, part of the Question Forums category; I want to display data within a chart in descending order without sorting the data source spreadsheet. Is this possible? ...

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    72

    Default

    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

  2. #2
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,889

    Default

    On 2002-06-17 12:01, Waxaholic wrote:
    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
    Yes, there is a way to do this - tough it involves creating your chart from PivoteTable:

    1) Create a PivoteTable by entering the wizard and selecting range.

    2) In Row field put the Names and in Data field put your Values.

    3) When clicking twice on the Row PivoteTable field (Names) you can choose to sort your Values by entering the "Advanced..." option and choosing the field to sort (Values).

    4) Create your Bar chart from the PivoteTable and Refresh it whenever you need.

    Your plot will be sorted with no need to sort the original data.
    Hope this make sense!

    Eli


    [ This Message was edited by: eliW on 2002-06-17 23:48 ]

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com