| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table charts
Hi
Is there any way that you can you stop a pivot chart updating when the source data changes? Thanks Diane |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 EditLinks 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
pivot table charts
Brilliant - why didn't I think of that!! Thanks
"Debra Dalgleish" wrote: 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 EditLinks 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| Pivot table charts | Charts and Charting in Excel | |||
| Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
| Pivot Table and Charts | Excel Discussion (Misc queries) | |||
Linear Mode
