Learn How To Quickly Create Charts For Any Region With This Microsoft Excel Tutorial

Windows Platform, Computing
Learn How To Quickly Create Charts For Any Region With This Microsoft Excel Tutorial
Page content

Strategy: There have been many pivot table examples in the book. It is also possible to make a chart that relies on a pivot table.

  1. Select a single cell in your data and choose Data – PivotTable and PivotChart. In Step 1 of the Wizard, change the last option button to create a pivot chart, as shown in Fig. 995. Hit Next.

  2. Confirm the data range in Step 2. Choose Next, as shown in Fig. 996.

  3. In Step 3, choose Finish, as shown in Fig. 997.

You will be presented with a blank pivot chart, as shown in Fig. 998.

  1. Drag the Revenue field from the Field list and drop it in the main part of the

chart, as shown in Fig. 999.

  1. Drag the Date field and drop it in the Category Fields area, as shown in Fig. 1000.

  2. Drag the Product field and drop it in the blue box near the legend on the right side of the chart, as shown in Fig. 1001.

  3. Drag the Region field and drop it in the Page Fields area.

Result: As shown in Fig. 1002, you can change the Region field to quickly produce a chart for each region.

Summary: You can use a pivot chart to create charts for several different regions.

Images

Fig. 995

Fig. 996

Fig. 997

Fig. 998

Fig. 999

Fig. 1000

Fig. 1001

Fig. 1002