1. Use your Excel pivot tables to create charts.

The purpose of this assignment is to practice using your Excel pivot tables to create charts.

Then use your charts to create a small PowerPoint deck.


Assignment Directions

Using your Pivot Table Assignment from last week, take that pivot table data and create 3 charts of your choice. Be thoughtful about your use of chart type, colors, and lines. The point of these visuals is to tell a story.

Create a PPT

Put these charts in a PowerPoint deck that includes:

  1. Title slide
  2. Chart 1
  3. Chart 2
  4. Chart 3

In your content slides (slides 2-4), be sure to include a title and a sentence that summarizes your chart. It could be something as simple as “Organic is the largest traffic source for this website”. The sentence should represent the key point you are trying to make about the chart.  Remember, the point of a visual is to tell a story.