Line chart with negative numbers - X-axis problem

G

Guest

There's probably a really easy solution to this, but I've made a chart out of
a spreadsheet that's got negative numbers in it. My X-axis labels are in the
middle of the chart now, and I'd like them to be along the bottom.

Can you help?

~Judi
 
G

Guest

Double click on the y-axis and on the scale tab, specify the y value where
you want the x-axis to cross.

Are you sure that you want a "Line" chart and not an "XY (Scatter)" chart?
The only difference between them is that the x-axis on a "Line" chart is
presumed to be categories instead of an arithmetic scale. If you think your
x values are numbers and they are not equally spaced, then a "Line" chart
will distort your graph by making them appear to be equally spaced. Even if
they are equally spaced, if you try to fit a trendline, the fitted parameters
from a "Line" chart will be calculated assuming that your x values were
1,2,3,... regardless of what you think the x values are.

Jerry
 

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

Bubble chart labels on x axis 2
x-axis scaling 2
Getting x axis values on bottom in a logarithmic scale chart 2
Fixing the X-axis for a line plot 2
Positioning x axis at bottom of chart with negative values 5
Chart with Columns on Y axis and lines on x -where are you Jon Pel 5
Changing the data label position below the chart axis. 2
Creating a line chart with two X-axes!! 1

Top