How to plot two sets of data against each other in Excel

Plotting two series against each other"ValerieD" wrote in message...For Physics, I need to plot one set of data vs. another. I tried makingtwocolumns, the first column had the val

How to plot two sets of data against each other in Excel
Default

Plotting two series against each other


"ValerieD" wrote in message
...
For Physics, I need to plot one set of data vs. another. I tried making
two
columns, the first column had the values I wanted as the x axis. The
second
column I put the values I wanted to be plotted as the y axis. The problem
is
that when it makes a graph, it plots it as two lines. How do I make one
set
of values be the x axis and one set the y axis so I get one line from two
sets of values.

Select the two columns, Insert/ Chart ... and choose X-Y (scatter) graph.
This "scatter" naming continues to confuse new users, as this is what you
use to produce a *line* graph of Y against X.
--
David Biddulph

Video liên quan