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: www.excelforum.com/member.php...oamp;userid=33428
View this thread: www.excelforum.com/showthread...hreadid=534154quot;gailb14quot; gt; wrote in
message ...
gt;
gt; My chart has positive and negative values. The axis labels appear at
gt; 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
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: www.excelforum.com/member.php...oamp;userid=33428
View this thread: www.excelforum.com/showthread...hreadid=534154
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: www.excelforum.com/member.php...oamp;userid=33428
View this thread: www.excelforum.com/showthread...hreadid=534154Hi,
You will find instructions here,
www.andypope.info/tips/tip002.htm
Cheers
Andy
gailb14 wrote:
gt; My chart has positive and negative values. The axis labels appear at
gt; the 0 value. How do I move them to the side of the chart.
gt;
gt;
--
Andy Pope, Microsoft MVP - Excel
www.andypope.info
quot;gailb14quot; gt; wrote in
message ...
gt;
gt; My chart has -10 -5 0 5 10
gt; The labels are at the 0. I must not understand your instructions
gt; Value Y axis crosses at category (1)
gt; Value Y axis crosses between categories (checked)
gt; Value Y axis crosses at maximum category (checked)
gt;
gt; 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
- Mar 13 Thu 2008 20:43
Axis labels on negative values
close
全站熱搜
留言列表
發表留言