Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Positioning x axis at bottom of chart with negative values

Im 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?
Thank you
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Positioning x axis at bottom of chart with negative values

To position the X axis at the bottom of the chart with negative values in Microsoft Excel 2007, follow these steps:
  1. Select the chart by clicking on it.
  2. Right-click on the chart and select "Format Chart Area" from the drop-down menu.
  3. In the "Format Chart Area" dialog box, click on the "Axes" tab.
  4. Under the "Axes" tab, select the X axis and click on the "Horizontal axis crosses" drop-down menu.
  5. Select "Axis value" and enter
    Formula:
    "0" 
    in the input box.
  6. Click "Close" to close the dialog box.

This should position the X axis at the bottom of the chart with negative values. If you have any further questions, feel free to ask.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 563
Default Positioning x axis at bottom of chart with negative values

Format the y-axis and specify what value is to cross the x-axis
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Debs1967" wrote in message
...
Im 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?
Thank you


  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Positioning x axis at bottom of chart with negative values

Hi,

Not sure 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.

Cheers
Andy

On 25/02/2010 14:22, Debs1967 wrote:
Im 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?
Thank you


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 833
Default Positioning x axis at bottom of chart with negative values

Try this:-

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 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.

If my comments have helped please hit Yes.

Thanks.

"Debs1967" wrote:

Im 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?
Thank you



  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Positioning x axis at bottom of chart with negative values


Thank you for your advice but it hasn't worked for me. Maybe I'm doing
something wrong.

"trip_to_tokyo" wrote:

Try this:-

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 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.

If my comments have helped please hit Yes.

Thanks.

"Debs1967" wrote:

Im 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?
Thank you

  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 833
Default Positioning x axis at bottom of chart with negative values

OK, sorry, don't know what else to suggest at this point.

"Debs1967" wrote:


Thank you for your advice but it hasn't worked for me. Maybe I'm doing
something wrong.

"trip_to_tokyo" wrote:

Try this:-

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 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.

If my comments have helped please hit Yes.

Thanks.

"Debs1967" wrote:

Im 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?
Thank you

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Negative values on X axis Kell2604 Charts and Charting in Excel 6 February 20th 09 11:31 PM
Data labels along below x axis when y axis has negative values Andrew Charts and Charting in Excel 1 July 3rd 08 08:36 PM
Getting x axis values on bottom in a logarithmic scale chart Steven Excel Discussion (Misc queries) 2 June 12th 07 06:46 PM
Negative values in bar chart overlap axis labels. Bonny Charts and Charting in Excel 1 August 17th 06 08:34 AM
Simple question- how to make X axis on bottom of chart Boon8888 Charts and Charting in Excel 2 February 8th 06 06:13 AM


All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"