How do i set up two series on a scatter plot?

Y

yellastang

I need to set up two series on my scatter plot so that I can do two
trendlines to find my stoichiometric point from all data gathered in my
chemistry lab class.
 
J

Jon Peltier

Make the chart as usual with one of the series. Copy the range containing X and Y
values for the next series, select the chart, and use Paste Special from the Edit
menu to add a New Series, Categories in First Column. Now do a trendline for each
series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.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

Top