Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question

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


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.