O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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 Chart from PivotTable Report Data

What if you don't want to create a PivotChart that interacts with the data in the PivotTable report? You can create an ordinary, non-interactive chart to represent the pivot table data. To do so, select the data in the PivotTable report that you want to include in your chart. If you want to include field button data in the first row and column of the PivotTable report, select the data by dragging from the bottom right corner of the data.

Click the Copy button on the Standard toolbar. Click in a cell in a blank area. Choose Edit, Paste Special. Click Values, and then click OK. Create your chart using ...

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