X axis lables on a + and - scale?!?

  • Thread starter Thread starter chadt74
  • Start date Start date
C

chadt74

I have a line graph which has both positive and negative numbers.

The problem is that I want to show the X axis labels on the graph but
the labels get thrown in the middle of the graph on the zero line and
I want them on the bottom, is there anyway I can do this (I'm sure
there is!)

For example if I have profit by month for 12 months I would have

01 100K
02 -500K
03 250K
04 100K
05 -100K

etc...

And If I wanted to graph that I should show the 01, 02,03 at the very
bottom of the graph, not in the middle.

Thanks in advance!
 
Chad -

Double click on the axis, and on the Patterns tab, select the Low option for Tick
Labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Thank you so much, that is all I needed. Sorry for the easy question,
but I play with Excel, not graphs so much!!

Thanks again
 
Back
Top