Plotting X and Y to a single point

M

mea

I would like to create a graph where the x value and y value are plotted as a
single point on the graph (I have 10 points I want to graph and I keep
coming up with 20). Seems like a common thing to do, but I can't find it.
Thank you
 
M

Mike Middleton

mea -

Arrange the data in ten adjacent rows in two adjacent columns with X values
in the left column and associated Y values in the right column. Select the
entire data range (20 cells). Click the Chart Wizard (or choose Insert |
Chart), and select the XY (Scatter) chart type.

- Mike
www.mikemiddleton.com
 
B

B. R.Ramachandran

Hi,

Are you by any chance choosing "Line Plot" for the Chart Type? You should
choose "XY (Scatter)".

Regards,
B. R. Ramachandran
 

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

Plotting Graph with dynamic table 3
Use text descriptors as Y axis units 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Non Linear Scatter plot, need to find y value 3
Make Y-axis values correspond to x- axis value 1
Plot value at top of chart 1
Scatterpoot not using X values properly -- using relative ranking 3
Charting scientific data - Excel 2003 5

Top