Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Judi" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line chart with negative numbers - X-axis problem | Excel Discussion (Misc queries) | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
How do I set Line chart y Axis variable X axis value? | Charts and Charting in Excel | |||
Negative numbers on X axis | Charts and Charting in Excel |