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 have 2 columns of numbers, column A i want to be the X axis of a line graph, and column B to be the Y axis. Whenever i select the range, Excel just gives me two series instead of plotting one against the other. I am obviously missing something.


share|improve this question

migrated from Jan 23 '10 at 16:39

This question came from our site for professional and enthusiast programmers.

up vote 0 down vote accepted

I'm only an intermediate Excel user, but:

  • make sure you choose XY chart,
  • even then you might need to go into the chart's properties and assign one range to the X axis and one to the Y axis (I assume there is a better way, but I don't know it)
share|improve this answer
thanks. Its called a scatter (XY chart) for some reason. We learned in school, this was a line graph! – joec Jan 23 '10 at 16:38

Just simply pick scatter plot and you get x vs. y for the selected cells. My daughter had the same issue trying to do some homework and I finally figured it out.

share|improve this answer

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.