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.
Cet exercice fait partie du cours
<cours>Analyse marketing dans Google Sheets</cours>Instructions de l’exercice
- Using the table located in the range
H1:K3, add the seriesGoal Completionsas a series to the existing bar chart. - Modify the stacking type to be
Standard.
Exercice interactif pratique
Transformez la théorie en action avec l’un de nos exercices interactifs
Commencer l’exercice