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.
Este exercício faz parte do curso
Marketing Analytics in Google Sheets
Instruções do exercício
- 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
.
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
