+ Reply to Thread
Results 1 to 3 of 3

Can you sort a chart out in Ascending/Descending Order

  1. #1
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Can you sort a chart out in Ascending/Descending Order

    Please see attached doc.

    The four macro buttons change the graph to show the specific month. Is there a way where i can sort the bars out so that the longest bar is at the top and the shortest at the bottom, or visa versa.

    Like data sorting a table, but sorting the graph instead.

    Thanks for your help...
    Attached Files Attached Files

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Can you sort a chart out in Ascending/Descending Order

    You will have to sort the series data in the table.
    Just add the sort code to the existing code for each button.

    If it is important to retain the existing order of the data, then

    1. Create a copy of the data table and use it for the chart series, or
    2. Add a helper column containing numbers for each row of data, in ascending increments, and re-sort on this field in ascending when required to restore original order of the data.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Re: Can you sort a chart out in Ascending/Descending Order

    Thanks for your help. I have decided to create a copy of the table, and sort it from there, as you suggested. See updated attachment.

    I have now tried to add the %'s to the graph, but i want them shown as lines as opposed to the bars. As you can see i have added the series to the graph but the lines are not showing.

    Any suggestions? Thanks once again.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1