X Axis in line graph

[MelaniePPC]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am using a line graph in Excel to represent ROI for the past 12 months (Jan – Dec). So, Axis Y represents the ROI % while Axis X represents the month of the year. The problem that I am having is that there were a couple of months where the ROI was negative so therefore the lines on the graph dip below 0. However, the labels on the X axis stay at the 0 line so the labels are appearing in the middle of the graph rather than at the very bottom. Does anyone know how to fix this?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am using a line graph in Excel to represent ROI for the past 12 months (Jan
– Dec). So, Axis Y represents the ROI % while Axis X represents the month of
the year. The problem that I am having is that there were a couple of months
where the ROI was negative so therefore the lines on the graph dip below 0.
However, the labels on the X axis stay at the 0 line so the labels are
appearing in the middle of the graph rather than at the very bottom. Does
anyone know how to fix this?

That depends on what you want to see. You can change the axis crossing
value, so the bottom of the graph is at the lowest ROI.

 

[MelaniePPC]

Hi Bob, that is exactly what I want...for the X axis to show at the very bottom of the of the graph (the lowest ROI). I can't figure this out for the life of me!

 

[Bob Greenblatt]

Hi Bob, that is exactly what I want...for the X axis to show at the very
bottom of the of the graph (the lowest ROI). I can't figure this out for the
life of me!

Control click on the y axis. Select format axis. On the scale tab, set the
crossing value.

 

[MelaniePPC]

Nevermind, I figured it out! Thanks for letting me know it was a possibility!