Change a PivotChart report to a static chart

Microsoft Office Excel 2003

previous page next page
  • Find and click the associated PivotTable report for the PivotChart report.

    ShowHow?

    This report has the same name as the PivotChart report. To check the name:

    1. Click the PivotChart report.
    2. Click PivotChart on the PivotTable toolbar.
    3. Click Options, and note the name in the Name box.
    4. Click each PivotTable report in the workbook, click PivotTable on the PivotTable toolbar, click Table Options, and check for the same name in the Name box.
  • On the PivotTable toolbar, click PivotTable, point to Select, and then click Entire Table.
  • Press DELETE.

    • ShowTip

    If the worksheet containing the associated PivotTable report doesn't have any data you want to keep, you can delete the entire worksheet instead of deleting just the report. On the Edit menu, click Delete Sheet.

    previous page start next page