Get startedGet started for free

Ad group impression share with a doughnut chart

Once again, the marketing manager at your agency simply does not like the look and feel of a pie chart. In addition, they feel like the percent make up of total Impressions is more important than Cost, which is what it currently reports.

Knowing all of the issues, you now need to modify the chart accordingly.

Note: Columns A through G are minimized in this exercise. From this exercise through the rest of the exercises in chapter 4, A:G will remain hidden.

This exercise is part of the course

Marketing Analytics in Google Sheets

View Course

Exercise instructions

  • In the pie chart, replace the series Cost with Impressions from the aggregate table located in range K1:O4.
  • Change the chart type from a pie chart to a doughnut chart.
  • Analyze the Bing source data by switching to Bing in the source dropdown.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise