Because pivot charts are so dense, many of the specialized chart types don't work well. Instead, stick with simple chart types like column charts and pie charts. One popular choice is the stacked column chart, which helps you see the breakdown of your various groups.

Before you create a pivot chart, it's often useful to limit the amount of information in your pivot table. Too much information can lead to a chart that's hard to read. Avoid using too many levels of grouping, and use filtering (as described in the previous section) to cut down on the total amount of information that's shown in the pivot table.