I have a line graph with positive & negative numbers.

However, the data labels on the x-axis display directly below the 0 line.

Can anyone tell me how I can format the graph so that the labels show below
the bottom (negative value) line.

Many thanks

Hi,

There is an explanation here,
http://www.andypope.info/tips/tip002.htm

Cheers
Andy

gunga wrote:
I have a line graph with positive & negative numbers.

However, the data labels on the x-axis display directly below the 0 line.

Can anyone tell me how I can format the graph so that the labels show below
the bottom (negative value) line.

Many thanks

--

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

One way:

CTRL-Click on the vertical axis and choose Format axis... In the scale
tab, uncheck the "Category (X) axis Crosses at:" and enter the Minimum
value (or more negative) in the textbox.

In article ,
"gunga" wrote:

I have a line graph with positive & negative numbers.

However, the data labels on the x-axis display directly below the 0 line.

Can anyone tell me how I can format the graph so that the labels show below
the bottom (negative value) line.

Many thanks

Double click on the axis or the numbers for the axis.
select paterns and select Tick mark labels "Low"

"gunga" wrote:

I have a line graph with positive & negative numbers.

However, the data labels on the x-axis display directly below the 0 line.

Can anyone tell me how I can format the graph so that the labels show below
the bottom (negative value) line.

Many thanks

Brilliant - thanks Andy

"Andy Pope" wrote:

Hi,

There is an explanation here,
http://www.andypope.info/tips/tip002.htm

Cheers
Andy

gunga wrote:
I have a line graph with positive & negative numbers.

However, the data labels on the x-axis display directly below the 0 line.

Can anyone tell me how I can format the graph so that the labels show below
the bottom (negative value) line.

Many thanks

--

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