• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 18. Working with Pivot Tables > Creating a Chart from PivotTable Report Da...

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 the Chart Wizard. For instructions on how to use the Chart Wizard, see Chapter 12, “Adding a Chart.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint