Forcing 'XValues' to the bottom
 

I have a line chart with positive and negative numbers as 'Values'. My x-axis
legend (the 'XValues') appears in the middle of the screen - along the x
axis. I want it to appear at the bottom. Any suggestions?

Hi jeff,

Double click the x axis and on the Patterns Tab select Tick mark labels:
Low.

Cheers
Andy

jeff wrote:
I have a line chart with positive and negative numbers as 'Values'. My x-axis
legend (the 'XValues') appears in the middle of the screen - along the x
axis. I want it to appear at the bottom. Any suggestions?

--

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

Go to the FORMAT AXIS menu and change the value for "Value (X) axis crosses
at" to a reasonable value. Do not re-select the check box to the left or it
will autoscale again.

Have a great day!
Barb Reinhardt

"jeff" wrote in message
...
I have a line chart with positive and negative numbers as 'Values'. My
x-axis
legend (the 'XValues') appears in the middle of the screen - along the x
axis. I want it to appear at the bottom. Any suggestions?

Both were great ideas and did the trick. Thanks very much!

"Barb Reinhardt" wrote:

Go to the FORMAT AXIS menu and change the value for "Value (X) axis crosses
at" to a reasonable value. Do not re-select the check box to the left or it
will autoscale again.

Have a great day!
Barb Reinhardt

"jeff" wrote in message
...
I have a line chart with positive and negative numbers as 'Values'. My
x-axis
legend (the 'XValues') appears in the middle of the screen - along the x
axis. I want it to appear at the bottom. Any suggestions?