+ Reply to Thread
Results 1 to 2 of 2

how to have my bar chart show the highest values on the left, and the lowest values right?

  1. #1
    Registered User
    Join Date
    10-17-2014
    Location
    london
    MS-Off Ver
    7
    Posts
    33

    how to have my bar chart show the highest values on the left, and the lowest values right?

    Is there any way to do this automatically? I just need to display the highest values on the left, and the lowest values on the right in order to create a nice uniform bar chart.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: how to have my bar chart show the highest values on the left, and the lowest values ri

    charts do not rank.
    you need to rank the source data.
    Cheers
    Andy
    www.andypope.info

+ 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. sorting out values from highest to lowest using VBA
    By royalB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2014, 08:22 AM
  2. Ignore Highest and Lowest Values
    By DanRandles in forum Excel General
    Replies: 7
    Last Post: 09-30-2013, 06:23 PM
  3. Continuous changing cell values - record highest and lowest values in seperate cells
    By attienel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2013, 05:12 PM
  4. Average, except highest and lowest values
    By tiwas in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-06-2012, 12:27 PM
  5. removing lowest and highest values
    By maco in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-13-2009, 05:10 PM
  6. Finding Highest values and Lowest Values
    By jpthelpguy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-22-2009, 03:30 AM
  7. Return highest/lowest 6 values from a list
    By thekingsoutlaw in forum Excel General
    Replies: 4
    Last Post: 01-21-2008, 04:36 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