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 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.

Thanks

share|improve this question

migrated from stackoverflow.com Jan 23 '10 at 16:39

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

2 Answers 2

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

 
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.