Excel axis problem
Posted
by itid
on Super User
See other posts from Super User
or by itid
Published on 2010-04-25T09:02:14Z
Indexed on
2010/04/25
9:03 UTC
Read the original article
Hit count: 128
excel-2007
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
© Super User or respective owner