Formatting X-axis

  • Thread starter Thread starter Adam Cunningham
  • Start date Start date
A

Adam Cunningham

I have a chart that is plotting both positive and negative numbers. Is is
possible to have the x-axis (value axis) at the bottom of the chart and not
just at either the top or the zero value on the y-axis?

Thanks,
Adam
 
Hi Adam,
Suppose your most negative value is -4. Right clcik the Y-axis, select
Format. On the Scale tab set Crosses X Axis to the value -4.

Best wishes
Bernard
 
Bernard said:
Suppose your most negative value is -4. Right clcik the Y-axis, select
Format. On the Scale tab set Crosses X Axis to the value -4
Click to expand...

To add to that suggestion, if your most negative value is -4, you can set
the value to -999. Now your x-axis will appear at the bottom even if your
data changes and your minimum value is >-999.

Dave
dvt at psu dot edu
 
Back
Top