Axis labels on negative values
 

My chart has positive and negative values. The axis labels appear at
the 0 value. How do I move them to the side of the chart.


--
gailb14
------------------------------------------------------------------------
gailb14's Profile: http://www.excelforum.com/member.php...o&userid=33428
View this thread: http://www.excelforum.com/showthread...hreadid=534154

Axis labels on negative values
 

"gailb14" wrote in
message ...

My chart has positive and negative values. The axis labels appear at
the 0 value. How do I move them to the side of the chart.

Format Axis/ Scale/ Value (X or Y) axis crosses at ...
--
David Biddulph

Axis labels on negative values
 

My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)

This is not working


--
gailb14
------------------------------------------------------------------------
gailb14's Profile: http://www.excelforum.com/member.php...o&userid=33428
View this thread: http://www.excelforum.com/showthread...hreadid=534154

Axis labels on negative values
 

My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)

This is not working


--
gailb14
------------------------------------------------------------------------
gailb14's Profile: http://www.excelforum.com/member.php...o&userid=33428
View this thread: http://www.excelforum.com/showthread...hreadid=534154

Axis labels on negative values
 

Hi,

You will find instructions here,
http://www.andypope.info/tips/tip002.htm

Cheers
Andy

gailb14 wrote:
My chart has positive and negative values. The axis labels appear at
the 0 value. How do I move them to the side of the chart.



--

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

Axis labels on negative values
 

"gailb14" wrote in
message ...

My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)

This is not working

I don't know what sort of chart you're using. You may find that XY scatter
gives you more flexibility.
--
David Biddulph