Why did Pivot table charts copied into workbook with standard cha.

G

Guest

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?
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot chart loses data connection when copied to new workbook 1
Odd Excel 2007 behavior: copied chart linked to source sheet 4
XL2007 Pivot Charts: Path to data in another workbook keeps chang 3
Set uniform scaling for same type of Pivot charts with varying dat 1
charts and pivot tables 2
Pivot charts & tables 13
Charts from pivot table 1
What does Excel do when copying sheets containing a lot of Charts? 3

Top