+ Reply to Thread
Results 1 to 5 of 5

How do I get a bar graph on Excel to sort from lowest to highest?

  1. #1
    Forum Contributor
    Join Date
    07-09-2018
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    256

    How do I get a bar graph on Excel to sort from lowest to highest?

    I have a 2d bar graph and want to sort from the lowest to the highest, the numbers are dynamic?

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How do I get a bar graph on Excel to sort from lowest to highest?

    Not quite sure what you're getting at. Any chart will be ordered based on the relative size of the series values.

    If the values are changing because they're dynamic and you still want an ordere by value series then you'll need to sort the series.

  3. #3
    Forum Contributor
    Join Date
    07-09-2018
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    256

    Re: How do I get a bar graph on Excel to sort from lowest to highest?

    This is a sample worbook. The values are not sorted from lowest to highest.
    Attached Files Attached Files

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How do I get a bar graph on Excel to sort from lowest to highest?

    Those numbers aren't dynamic they are fixed. Neither have you sorted them.

    Put a column label in J3 and onclude that in the sort range. At the moment you are ony sorting the bottom two values.

  5. #5
    Forum Contributor
    Join Date
    07-09-2018
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    256

    Re: How do I get a bar graph on Excel to sort from lowest to highest?

    Thanks for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sort lowest to highest in rows
    By RobinPrice in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-25-2016, 12:36 AM
  2. [SOLVED] Cant sort % highest to lowest?
    By mikey42979 in forum Excel General
    Replies: 6
    Last Post: 12-10-2015, 02:39 PM
  3. auto sort highest to lowest
    By B1G0 in forum Excel General
    Replies: 3
    Last Post: 04-02-2014, 05:37 PM
  4. How to sort from highest to lowest
    By dneunabe in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-22-2013, 04:49 PM
  5. how to sort time lowest to highest
    By Auzzie_Dazza in forum Excel General
    Replies: 1
    Last Post: 03-31-2012, 09:40 AM
  6. How do I sort ascend from highest to lowest
    By JennyC in forum Excel General
    Replies: 1
    Last Post: 08-08-2006, 08:25 PM
  7. Sort from lowest to highest
    By Steved in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-10-2005, 08:07 PM

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