Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move the Y axis below negative values | Charts and Charting in Excel | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Negative Values Only | Excel Discussion (Misc queries) | |||
How do I move the Category Axis labels outside of the Plot Area? | Charts and Charting in Excel |