Regional performance quadrant
Scatter plots work great when comparing the performance of various categories across two measures plotted along X- and Y-axis. An optional third measure can be added, defining the size of the data points on the chart. Could this be the most versatile chart ever?
In this exercise, we will use it to analyze how the Regions stack up against each other when it comes to sales, profit, and quantity.
If you lost progress, close any open reports and load 2_4_scatter_plot.xlsx
from the Workbooks folder.
This exercise is part of the course
Data Visualization in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
