If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Area graph problem.
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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...chart/200708/1 |
#2
|
|||
|
|||
Area graph problem.
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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "blingting via OfficeKB.com" u36811@uwe wrote in message news:776f5034c6bbc@uwe... 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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...chart/200708/1 |
#3
|
|||
|
|||
Area graph problem.
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 _______ "Bernard Liengme" wrote in message ... 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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "blingting via OfficeKB.com" u36811@uwe wrote in message news:776f5034c6bbc@uwe... 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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...chart/200708/1 |
Thread Tools | |
Display Modes | |
|
|