Results 1 to 4 of 4

Thread: How to position X axis in Excel chart with negative values in it

  1. #1
    Join Date
    Jan 2011
    Posts
    12

    How to position X axis in Excel chart with negative values in it

    I am using Office 2007 and have a simple line chart with negative values on the Y axis. I have ticked the 'values in reverse order' on the Y axis but the X axis flipped to the top of the chart. How can I keep it at the bottom please.

  2. #2
    Join Date
    Jul 2011
    Posts
    440

    Re: How to position X axis in Excel chart with negative values in it

    Format the y-axis and specify what value is to cross the x-axis. Then check back. I think this might work for you.

  3. #3
    Join Date
    Jul 2011
    Posts
    434

    Re: How to position X axis in Excel chart with negative values in it

    I am not sure whether you want to reverse the order of the values. Select the horizontal axis and then on the Axis Option section of the Format dialog set the Axis Labels to the Low position.

  4. #4
    Join Date
    Aug 2011
    Posts
    460

    Re: How to position X axis in Excel chart with negative values in it

    Try the below:
    1. Click in the X axis to where it has flipped to highlight it (a box should be placed around the axis to show that this has happened).
    2. Chart Tools / Format / Current Selection group / make sure that Horizontal (Category) Axis is showing in the Current Element box (the only one that has a drop down arrow in it) / Format Selection / Format Axis pane should then launch with Axis Options highlighted in orange on the left hand side / on the right hand side, in the Axis labels: box, change it to read Low then Close / this should cause the X axis to move back to the bottom of the chart.

Similar Threads

  1. How to disable excel for taking empty cell in Excel chart
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 25-02-2012, 12:30 PM
  2. Data points in Excel chart not lining up with axis
    By mbbackus in forum MS Office Support
    Replies: 1
    Last Post: 10-01-2012, 11:58 AM
  3. Excel Function and Excel Chart Colors
    By Samarth in forum Windows Software
    Replies: 5
    Last Post: 13-01-2010, 08:16 PM
  4. Hiding zero values on a chart in Excel 2007
    By mellisahi in forum Windows Software
    Replies: 4
    Last Post: 12-11-2009, 09:37 AM
  5. How to convert negative values from php to positive
    By TechPredator in forum Software Development
    Replies: 3
    Last Post: 06-08-2009, 01:03 PM

Tags for this Thread

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
  •  
Page generated in 1,713,256,345.23427 seconds with 17 queries