Simple MS Excel Graph question

[ZedCar]

I was watching this YT film about plotting on Excel.



I copied the numbers from the film into an Excel sheet and plotted x against y1 and got a blue coloured plot.

Then I plotted x against y2 and plotted a chart again. Though a second red coloured plot did not appear as in the film. Instead my original plot vanished and the second plot appeared, but again in blue.

How do I have both the x against y1 in blue, and the x against y2 in red on the same scatter plot?

Thank you.

 

[Integral]

A scatter plot of 2 lines requires 3 columns. x, y1, y2

 

[Andre]

Try this,

Make a selection (drag the mouse) from the header of X0 the upper left corner to Y2n, the lowermost right datacell. Then insert graph, scatter plot. That should do it.

 

[ZedCar]

Thanks Guys!

 

[alphy]

I would suggest checking your data and making sure that your x values are properly matched with their corresponding y values for both y1 and y2. It is also important to make sure that the data is properly formatted before creating the graph. Additionally, you may need to adjust the settings on the graph to show both plots in different colors. If you are still having trouble, I would recommend consulting Excel's help resources or reaching out to a colleague who is familiar with using Excel for data visualization.