Analyze cost data with a stacked area chart
The digital marketing director at your company is in dire need of some trends, as they are behind on a report. The silver lining is that the chart is already partially completed.
This chart needs to report on the makeup of total cost per month over the last 6 months. A stacked area chart will do the trick, as it displays the aggregate cost per month, and displays the breakdown of the trends.
This exercise is part of the course
Marketing Analytics in Google Sheets
Exercise instructions
- Add the cost column for
Google
to the chart as another series. - Modify the chart type to be a stacked area chart, instead of an area chart.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
