Microsoft Office Tutorials and References
In Depth Information
A pivot chart is a graphical representation of a data summary displayed in a pivot table. If you're familiar with
creating charts in Excel, you'll have no problem creating and customizing pivot charts. All Excel charting fea-
tures are available in a pivot chart.
Excel provides several ways to create a pivot chart:
• Select any cell in an existing pivot table and then choose PivotTable Tools Analyze Tools PivotChart.
• Select any cell in an existing pivot table and then choose Insert Charts PivotChart.
• Choose Insert Charts PivotChart PivotChart. Excel prompts you for the data source and creates a pivot
chart.
• Choose Insert Charts Pivot Chart PivotChart & PivotTable. Excel prompts you for the data source, and
creates a pivot table and a pivot chart.
A pivot chart example
Figure 18-52 shows part of a table that tracks daily sales by region. The Date field contains dates for the entire
year (excluding weekends), the Region field contains the region name (Eastern, Southern, or Western), and the
Sales field contains the sales amount.
This workbook, named sales by region pivot chart.xlsx, is available at this topic's web-
site.
Search JabSto ::




Custom Search