Area graph problem.

[blingting via OfficeKB.com]

Hello,
I have two columns of data, one for Chainage, and one for Elevation.
Basically, it's the data of a track; the chainage is the total distance of a
particular track point from the starting, and the elevation is the elevation
of that particular track point.

Anyhow, when I plot an Area graph with the elevation being the Y-axis, and
the Chainage being the X-axis, the Chainage doesn't seem to maintain a
constant interval.

For example, the total chainage is from 0 to 115 km, and total elevation
difference is from 2000m to 4000m. In the Y-axis, the elevation has an
interval of 25 m, but in the X-axis, the chainage doesn't maintain a specific
distance as the interval. Somewhere the interval is 3, and somehwere 4...
again somewhere it's 2.. not sure why.

How do I specify a constant interval for the X-axis in an Area graph.

Thanks!

 

[Bernard Liengme]

A very common problem: you have made a Line chart when you need an XY chart.
Line charts are used for "category" data while XY charts are used for true
numeric data. Just right click the chart and change its type - you can still
have your line joining the data points in an XY chart. MS must think of
another name for Line charts.
best wishes

 

[Jon Peltier]

You actually can use an area chart in this way, but you have to change the
axis to a time scale axis (Chart menu > Chart Options > Axes tab), then
apply a 'General' or other non-date number format to the axis.

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

A very common problem: you have made a Line chart when you need an XY
chart. Line charts are used for "category" data while XY charts are used
for true numeric data. Just right click the chart and change its type - you
can still have your line joining the data points in an XY chart. MS must
think of another name for Line charts.
best wishes