Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

You could try using a scatter / XY chart type.

Alternatively, you could tell Excel that the X values are dates(!): Excel then inserts the "missing" days and, for a column type chart leaves the column blank.

share|improve this answer
    
Thanks Neal, the scatter type worked well. –  itid Apr 26 '10 at 23:00

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.