trying to plot y against x

E

ernestgoh

hi guys, can anyone help me out?

when i select line option in charts, excel keeps drawing a chart with
two lines. what i really want is to plot $ as my y axis and t as my x
axis (in example below). how do i do it?

$ t
10 1
20 2
25 5
40 7

appreciate any advice. thanks.
 
M

Mike Middleton

ernestgoh -

(1) Use the XY (Scatter) chart type.

(2a) Specify data ranges using Chart | Source Data | Series (do not include
the top row labels), or

(2b) Arrange data with X on the left and Y on the right, and select the data
(without labels) before using the Chart Wizard.

- Mike
http://www.mikemiddleton.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to plot y against x 1
Plotting with 3 columns data (X,Y and Values) 1
How to draw a graph with the X axis as a time line of date. 4
How to use MSExcel to plot Column A against Col B? 8
Chart (scatter plot): values on X-axis. 1
Co-ordinates plotting on Graph //sk 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Unevenly spaced x axis on chart 1

Top