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.
To ćwiczenie jest częścią kursu
Marketing Analytics w Google Sheets
Instrukcje do ćwiczenia
- 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.
Interaktywne ćwiczenie praktyczne
Przekształć teorię w praktykę dzięki jednemu z naszych interaktywnych ćwiczeń
Rozpocznij ćwiczenie