[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
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.



Real-world example