Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
broncogirl
 
Posts: n/a
Default Scaling the x-axis on a line chart

I am having trouble scaling the x-axis so that the intervals are equal. The
source data is not in equal intervals, it goes
0.0,0.2,0.4,0.45,0.5,0.6,0.7,0.8,0.9 (I think). What can I do to make the
interval on the graph 0.2? I'm using XP.
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Don't make a line chart. Make an XY chart, using the markers and lines
option. Then you can double click the X axis and set any appropriate
tick spacing.

An XY chart treats X and Y as continuously varying numerical values. A
line chart treats Y that way, but treats X as non-numerical text labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


broncogirl wrote:

I am having trouble scaling the x-axis so that the intervals are equal. The
source data is not in equal intervals, it goes
0.0,0.2,0.4,0.45,0.5,0.6,0.7,0.8,0.9 (I think). What can I do to make the
interval on the graph 0.2? I'm using XP.

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
x axis labels/scale move to middle of chart w/neg & pos line cht rak Excel Worksheet Functions 1 August 30th 05 03:51 PM
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
make line in chart start at y axis Tone Charts and Charting in Excel 1 May 5th 05 09:23 AM
how to show date on the x axis of a line chart? Ginger Charts and Charting in Excel 4 May 1st 05 02:11 AM
Problems with X Axis for a Line Chart Shadowman13 Charts and Charting in Excel 3 February 18th 05 12:15 AM


All times are GMT +1. The time now is 10:38 PM.

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

About Us

"It's about Microsoft Excel"