| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
multiple pivotcharts from 1 pivot table?
I have a pivot table that I need to generate several charts from and I need
for each chart not to change when I change the data in the table. Is there a way to do this? All of these charts will be in the same workbook. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
multiple pivotcharts from 1 pivot table?
Each chart will change when the pivot table on which it's based changes.
Make a copy of the pivot table for each chart that you need, and base each chart on a copy. JJeter wrote: I have a pivot table that I need to generate several charts from and I need for each chart not to change when I change the data in the table. Is there a way to do this? All of these charts will be in the same workbook. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
multiple pivotcharts from 1 pivot table?
Debra,
I could have sworn that I saw somewhere that a PivotChart could be copied and made static so that it wouldn't change when the original Pivot Table changed. Thank you for your response. Jim Jeter "Debra Dalgleish" wrote: Each chart will change when the pivot table on which it's based changes. Make a copy of the pivot table for each chart that you need, and base each chart on a copy. JJeter wrote: I have a pivot table that I need to generate several charts from and I need for each chart not to change when I change the data in the table. Is there a way to do this? All of these charts will be in the same workbook. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
multiple pivotcharts from 1 pivot table?
Sorry, I thought you wanted each chart's layout to remain the same, if
the pivot table's layout changed. If you want a static chart, copy the chart, and paste it into a new workbook. Then, cut it from the new workbook, and paste it back into the original workbook. JJeter wrote: Debra, I could have sworn that I saw somewhere that a PivotChart could be copied and made static so that it wouldn't change when the original Pivot Table changed. Thank you for your response. Jim Jeter "Debra Dalgleish" wrote: Each chart will change when the pivot table on which it's based changes. Make a copy of the pivot table for each chart that you need, and base each chart on a copy. JJeter wrote: I have a pivot table that I need to generate several charts from and I need for each chart not to change when I change the data in the table. Is there a way to do this? All of these charts will be in the same workbook. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
multiple pivotcharts from 1 pivot table?
Debra,
Thank you. That seems almost too simple. :) I'll give it a shot. "Debra Dalgleish" wrote: Sorry, I thought you wanted each chart's layout to remain the same, if the pivot table's layout changed. If you want a static chart, copy the chart, and paste it into a new workbook. Then, cut it from the new workbook, and paste it back into the original workbook. JJeter wrote: Debra, I could have sworn that I saw somewhere that a PivotChart could be copied and made static so that it wouldn't change when the original Pivot Table changed. Thank you for your response. Jim Jeter "Debra Dalgleish" wrote: Each chart will change when the pivot table on which it's based changes. Make a copy of the pivot table for each chart that you need, and base each chart on a copy. JJeter wrote: I have a pivot table that I need to generate several charts from and I need for each chart not to change when I change the data in the table. Is there a way to do this? All of these charts will be in the same workbook. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Fields In Multiple Ranged Pivot Table | Excel Discussion (Misc queries) | |||
| build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
| how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
