Adding and formatting charts

Next up are charts. In this dashboard, we are going to insert two popular charts. We will add some formats to enhance how they appear in our dashboard.

The first chart is the area chart. This chart falls into the group of charts that are useful for visualizing trends. We are going to use this chart to show the trend of profits for the period that we select.

We will go through these steps:

1. Create a PivotTable in the Calculations sheet in cell Q10.
2. Put Months in the Row section and the Profit measure in the Values section.

This should give us the following PivotTable:

Figure 8.35 – Creating a PivotTable report on monthly profit

From here, we will select any cell in the PivotTable we just created and insert a PivotChart. In the chart options, we will select the Area chart:

Figure 8.36 – Inserting an area chart

We will reduce the clutter on the PivotChart by removing...