Home Charts Creating An XY Scattergraph In Excel

Creating An XY Scattergraph In Excel

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

Click 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

Further reading: 
Basic concepts 
Getting started with Excel
Cell References