The process isn’t quite as hard as it sounds, but you’ll need to understand exactly what you want before you go digging through Excel’s extended toolset. That said, scatter plots are limited ...

Two columns or rows of data in Microsoft Excel ... don't click one of the other types; if you do click inadvertently, you can simply click "Change Chart Type" and select "X-Y Scatter Plot" from ...

If you don't see one that you want, click the "All Charts" tab to see some more. When you click the "OK" button, Excel plots the chart for you and places it over your worksheet_. Drag or resize ...

You would notice that the line graph and scatter plot chart curves are different. However, these charts are static. You could also consider creating Dynamic charts in Excel. By doing this ...