Formatting X-axis

  • Thread starter Adam Cunningham
  • 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
 
B

Bernard Liengme

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
 
D

dvt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scatter Chart 1
Reversing Dates Sequence along X axis in a chart 3
Horizontal axis to the bottom 1
Pivot Chart - negative values not displaying properly 2
Overlapping 2 charts (XL2003) 2
How to draw a graph with the X axis as a time line of date. 4
X axis titles on logarithmic scatter chart. 5
simple bar chart, help please. 2

Top