Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
|
|||
|
|||
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:
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative values on X axis | Charts and Charting in Excel | |||
Data labels along below x axis when y axis has negative values | Charts and Charting in Excel | |||
Getting x axis values on bottom in a logarithmic scale chart | Excel Discussion (Misc queries) | |||
Negative values in bar chart overlap axis labels. | Charts and Charting in Excel | |||
Simple question- how to make X axis on bottom of chart | Charts and Charting in Excel |