Creating An XY Scattergraph In Excel

Follow to insert an X Y chart, but you need a data that looks something like this:

 

data tableClick insert, after marking the whole data (which in this case, is from A2 to C9).ribbon xy

Click on XY chart

click scatter chart

Choose desired design for your chart

scatter chart design

Note: Scatter chart is the XY chart.

The newly created XY chart:

xy chart created

Template

You can download the Template here – Download
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial