Horizontal axis in middle of chart

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Hi, I have a line graph where the vertical axis goes from -15 to 30.
The horizontal labels then appear in the middle of the chart where the
zero line is, how can I get the labels to be below the chart on the
-15 line? I am using excel 2007.

Thank You
Stephen
 
Steve,

This answer for Excel 2002, but I doubt it's changed in 2007.

First right-click the Y axis, most easily done by right-clicking one of its
labels. Select Format Axis. In the "Category axis crosses axis at" box put
a very negative number, more negative than any you'd ever expect.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

chart dates and times (excel 2007) 3
Aligning tick marks and labels on line charts or scatter charts 2
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Date-time axis in chart 1
Overlay charts in 2007 2
Scaling of data in Line chart 6
Word On a bar chart I want to have just one horizontal line, crossing the y axis at a value I determine. 1
How to draw a graph with the X axis as a time line of date. 4

Back
Top