How do I do this in Excel?

Question

I have to create 6 different graphs and plot them all on one graph in Excel. I have to create a linear, quadratic, polynomial, rational, exponential, and log. So far I have the linear and the quadratic done, but once I have them all, how do I plot them all on one graph??

Answer 1

Once you make a graph with one set of data, do the following:

1. Right-click in the blank white space on the graph and select Source Data
2. Go to the Series tab
3. Click the Add button
4. Give the new series a name if you like
5. Click in the X-values field, then select all the cells that correspond to the horizontal axis of the graph
6. Click in the Y-values field, then select all the cells that correspond to the vertical axis of the graph
7. Repeat for each additional set of data

Answer 2

The previous post is correct but omits an important first step: start with what Excel calls a "scatter plot" for your chart type.