Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default Line chart with negative numbers - X-axis problem

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 837
Default Line chart with negative numbers - X-axis problem

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line chart with negative numbers - X-axis problem Judi Excel Discussion (Misc queries) 0 March 28th 07 12:55 AM
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 10:16 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
How do I set Line chart y Axis variable X axis value? John T Charts and Charting in Excel 1 April 18th 05 04:36 AM
Negative numbers on X axis Dee Charts and Charting in Excel 4 March 29th 05 01:59 AM


All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"