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

[Guest]

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.

 

[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/
_______