If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why did Pivot table charts copied into workbook with standard cha.
Recently I created a workbook with standard charts (made by using the chart
wizard) on individual worksheets . Next I copied pivot table charts into the workbook, also on individual worksheets. (The pivot tables were on the sheets with the charts, not on separate sheets.) Although my original charts remained intact, most the pivot table charts disappeared from the worksheets, leaving only the pivot tables. Has anyone else encountered this problem? Is there a bug in the software that prevents pivot charts being in the same workbook as standard wizard charts? |
#2
|
|||
|
|||
I know of no reason that real charts and pivot charts can't coexist within the same
workbook. I've been mixing them for ages (though I must admit I avoid pivot charts when I can). Maybe if you stepped through and describe the procedure that led to this problem, someone might be able to help. Has it only happened once, or can you repeat the problem? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ TamaJo wrote: Recently I created a workbook with standard charts (made by using the chart wizard) on individual worksheets . Next I copied pivot table charts into the workbook, also on individual worksheets. (The pivot tables were on the sheets with the charts, not on separate sheets.) Although my original charts remained intact, most the pivot table charts disappeared from the worksheets, leaving only the pivot tables. Has anyone else encountered this problem? Is there a bug in the software that prevents pivot charts being in the same workbook as standard wizard charts? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Disable pivot chart ability? | Ted Horsch | Charts and Charting | 5 | August 23rd, 2004 07:49 PM |
Macro to extend a pivot table range | Debra Dalgleish | General Discussion | 1 | July 29th, 2004 11:56 AM |
Charts from Pivot Table | ksgoodwin | Charts and Charting | 1 | July 21st, 2004 03:47 AM |
Problem with Pivot Table | unplugs | New Users | 4 | June 1st, 2004 10:06 AM |
Export Pivot Table to Excel Sheet | Suntisuk | Using Forms | 0 | May 28th, 2004 08:56 PM |