A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old October 25th, 2004, 05:29 PM
TamaJo
external usenet poster
 
Posts: n/a
Default 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  
Old October 26th, 2004, 01:53 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.