Fixing a 3D chart
While working on the previous chart, your trainee analyzed the seasonality\(^1\) of sales. He's got a strong suspicion that while the start of the year is strong, Q3 and Q4 underperform year over year. He came up with another visualization that, unfortunately, needs your attention. Can you find a better way to compare Q3 and Q4 performance year over year visually?
1. Seasonality: a situation in time-series analysis in which the data has clear regular, and predictable changes that recur every calendar year/month/week.
If you lost progress, close any open reports and load 3_3_seasonality.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
