Re: pivot table charts

To make the pivot chart independent of the source pivot table:

Right-click on the pivot chart, and click Copy
Open a new workbook
Right-click on a cell, and click Paste
In the new workbook, choose Edit>Links
Click on Break Link, then click Break Link to confirm.
The pivot chart in the new workbook is now based on set values, that you can see in the formula bar, when you click on a series.

DianeG wrote:
Hi
Is there any way that you can you stop a pivot chart updating when the source data changes?

Thanks

Diane


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

.

Relevant Pages

  • RE: Index/Match Cell Limitation?
    ... Workbook Size ... ... WS5 … Pivot Chart ... What version of Excel? ... In general terms, how big is this workbook - # sheets, rows/columns used ...
    (microsoft.public.excel.misc)
  • RE: Chart Tools - Analyze Tab nissing ..
    ... original workbook. ... I deleted the chart and recreated and the Analyze Tab came back. ... I have two workbooks containing the same Pivot chart. ... There are no external links to the original from the copy and the data ...
    (microsoft.public.excel.charting)
  • Linking
    ... I have a workbook and inside the book is a sheet called pivot chart ... which already has a hyperlink set into it that will take you to a ...
    (microsoft.public.excel)
  • Re: Pivot table Data refresh
    ... SSD1 wrote: ... The names and data are extracted from other worsheets in the same workbook. ... When I delete the names and data to start a new analysis I refresh the Pivot Table and the Pivot Chart but the names still remain on the field name drop down box. ...
    (microsoft.public.excel.worksheet.functions)