Excel axis problem
- by itid
I am graphing the height above sea level obtained by GPS at 12 measuring stations, which are distributed along a straight line but NOT equidistantly.
Excel does a nice job of creating a suitable Y axis. But, it insists on placing the 12 stations equidistantly along the X axis.
Consequently, the line graph does not represent the true cross section of the terrain. It is only true at the stations themselves.
Surely there must be a way that I can enter the actual distances between the stations into a column, and get Excel to read from that column and space the values accordingly? It is such a basic mapping procedure for geologists and many others.
Thanks