[Excel] How to make a simple scatterplot

A scatterplot displays the relationship between two variables and is essential for higher level insights.

A simple scatterplot in Excel.

Design notes

• Check the aspect ratio.
• Reduce opacity to avoid occlusion (overlapping data points).
• Show dot outline using a darker color.

Video

Notes

Real-world example