+ Reply to Thread
Results 1 to 4 of 4

chart problem

  1. #1
    Forum Contributor
    Join Date
    02-11-2008
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    242

    chart problem

    Hi,
    I have this chart, where the logic of line chart is "lower is better",but as per general rule the greater line goes up,so how to do the reverse.
    Attached Files Attached Files

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: chart problem

    Select the Secondarly Vertical (Value) Series, either by selecting in the "Current Selection" dropdown and clicking the "Format Selection" button, or right-clicking on the axis in the chart and selecting "Format Axis" from the dropdown menu.

    In the "Format Axis" dialogue box
    Axis Options tab
    Click the "Values in reverse order" box to enable

    Now it will flip the orientation of the secondary axis so zero is at the top and bigger numbers go down.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,753

    Re: chart problem

    are you looking to change the RANK order so that the lowest value is ranked lower - not sure what you mean otherwise

    you have attached a chart , can you also show what you would like the chart to look like to get the results you expect
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: chart problem

    I just noticed that the thread title is probably an Rule 1 violation as well, that should probably be changed.

+ 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. xlLine chart - xlScatter chart - problem
    By smde in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2013, 07:00 AM
  2. Replies: 0
    Last Post: 11-20-2012, 05:14 AM
  3. Pie Chart Problem
    By sfar007 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-19-2006, 10:18 AM
  4. Chart Problem
    By Michael Ryle in forum Excel General
    Replies: 2
    Last Post: 01-20-2006, 07:10 PM
  5. chart problem
    By geepeetee in forum Excel General
    Replies: 5
    Last Post: 05-17-2005, 05:06 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