I have 2 columns of numbers:

  • Column A I want to be the X axis of a smooth line graph which goes through all of the data points which shows distance.
  • Column B I want to be the Y axis showing amplitude.

Instead of Column A as the X axis, I get a linear scale which does not truly represent the information I am trying to portray. Is there any way of achieving my needs?


I'm using Excel 2007, so YMMV, but have you tried an "X Y (Scatter)" chart? Excel "Change Chart Type" dialog

For example, example chart resulting from above choice

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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