Microsoft Office Tutorials and References
In Depth Information
Analyzing Data Using a PivotChart
Analyzing Data Using a PivotChart
To help you present PivotTable data, you can create a chart. A chart of a PivotTable
is called a PivotChart . With the PivotChart button, you can create a PivotChart or a
PivotChart and PivotTable at the same time with the control you need to get the results
you want. With this control, you can use multiple tables in a PivotChart using the Excel
Data Model ( New ! ). A PivotChart is not longer associated with a PivotTable ( New ! ). A
standalone PivotChart allows you to use the Drill Down, Drill Up, and Cross Drill to view
different levels of data details ( New ! ).
Create a PivotChart
Click anywhere within the table range or select a range of cells.
Click the Insert tab.
Click the PivotChart button, and then click PivotChart , or PivotChart &
PivotTable .
Click the Select a table or range option, or click the Use an external data
source option, click Choose Connection , and then select a connection/data
source.
Click the New worksheet option or Existing worksheet option, and specify a
cell range.
To use multiple tables in a PivotTable, select the Add this data to the Data
Model check box ( New ! ).
Click OK .
Search JabSto ::




Custom Search