Not all chart types are available in pivot charts.Pivot charts are plotted with category labels and series values in columns only.No data from outside the pivot table is allowed in the pivot chart. All data in the pivot table is plotted in the pivot chart, except for subtotals and grand totals.The pivot chart has optional field buttons that allow the same filtering capabilities directly in the chart that are available to the pivot table.If the pivot table changes size, the pivot chart changes the number of its plotted series, and changes the lengths of these series, to accommodate the updated pivot table size. Changes to the pivot table are reflected in the pivot chart, and vice versa. A pivot chart is linked to its parent pivot table.I used to avoid pivot charts because of these limitations, which included not being able to hide the field buttons and not being able to resize the plot area or move axis and chart titles. But Microsoft has kept improving them, and now the few remaining limitations seem pretty reasonable given the power and constraints of pivot tables themselves. A pivot chart is a special Excel chart, with some strengths and some limitations. If you select a pivot table and insert a chart, Excel inserts a pivot chart.
