Source performance using a standard stacked bar chart
The last part of the dashboard, from the requirements given by the marketing director:
A chart showing the total number of impressions, clicks, and goal completions by source
This seems like a simple column or bar chart. This is where having both options of column and bar come in handy. Here, a bar chart fits best, as a column chart would make the bars too compact, making the smaller values in the chart unreadable.
A bar chart has already been added for you beneath the previous charts. However, it needs some modifications to fulfill the marketing director's request.
This exercise is part of the course
Marketing Analytics in Google Sheets
Exercise instructions
- Using the table located in the range
H1:K3
, add the seriesGoal Completions
as a series to the existing bar chart. - Modify the stacking type to be
Standard
.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
