Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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 bought Excell 2010 but is confusing me a lot basically i just need to graph a

X and Y table but it is showing two lines (x is a line and Y is a line) while what i want is to show only one line X VS Y, i dont know why it is showing two lines as if the were independent..

Can anyone please advise how to use it?

PS my values are

X    Y
1.0    1.5
2.8    3.9
4.2    4.6

enter image description here

I am not sure what to add here? or where

share|improve this question

migrated from Oct 26 '11 at 16:01

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

up vote 1 down vote accepted

You are plotting them independently of each other. Easiest way to plot a graph is as follows:

1) create a blank graph from the "insert" tab

2) right click on the graph and "select data"

3) "add series" and highlight your x values in the 'x' input box, and y values in the 'y' input box. Series name is optional

4) select 'okay' twice. Voila.


share|improve this answer
Please see what comes up after I do "Select Data" i placed a screen shot. I do not see the x and y boxes – user710502 Oct 23 '11 at 21:03
You have to click "add" first, then they'll show up. – iKiar Oct 23 '11 at 21:06
(see bullet 3) ) – iKiar Oct 23 '11 at 21:07
+1 well covered – brettdj Oct 24 '11 at 0:57

You must log in to answer this question.