Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
x axis labels/scale move to middle of chart w/neg & pos line cht | Excel Worksheet Functions | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
make line in chart start at y axis | Charts and Charting in Excel | |||
how to show date on the x axis of a line chart? | Charts and Charting in Excel | |||
Problems with X Axis for a Line Chart | Charts and Charting in Excel |