O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a PivotChart

You can create a PivotChart by using the PivotTable And PivotChart Wizard (see Figure 30-4). Or you can first create a PivotTable and then, while any cell in the table is selected, click the Chart Wizard button on the PivotTable toolbar. If you take the first approach, Excel creates both a new PivotTable and a new PivotChart. If you take the second approach, Excel creates a PivotChart based on the current PivotTable.

Either way, the chart and table are linked. Changes to one are reflected in the other. Figure 30-10 shows a PivotChart that's linked to the PivotTable shown in Figure 30-9. Notice that the page fields of the PivotTable shown in Figure 30-9 appear at the upper left corner of the PivotChart, and the table's row ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required