Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default multiple charts from a single pivot table

Hi
can i create several pivot charts from a single pivot table?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,722
Default multiple charts from a single pivot table

Nope.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Yossi evenzur" wrote:

Hi
can i create several pivot charts from a single pivot table?

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 38
Default multiple charts from a single pivot table

No, but you can copy the pivot table to create another which uses the
same pivot cache, so they will refresh in synch with each other, and
share any grouping and calculated fields.
Filtering won't be synchronised though, so you may want to either
automate that with macros or use formaulas to check for basic
consistency eg grand grand totals are the same.

Adam

On 22/02/2010 13:00, Yossi evenzur wrote:
Hi
can i create several pivot charts from a single pivot table?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple charts on single chart sheet Brian Reilly, MVP Charts and Charting in Excel 3 October 18th 07 06:05 PM
Single Pivot Table 4 Multiple Sheets? FARAZ QURESHI Excel Discussion (Misc queries) 2 June 11th 07 08:37 AM
Single Pivot table for similar Multiple sheets? FARAZ QURESHI[_2_] Excel Discussion (Misc queries) 0 June 9th 07 06:46 AM
How do I create multiple pivot charts from one pivot table? Rudy Charts and Charting in Excel 1 March 17th 06 10:01 PM
Can links between Excel 2003 Pivot Charts and their pivot table b. Mark Allen Charts and Charting in Excel 2 March 5th 05 05:24 PM


All times are GMT +1. The time now is 11:16 PM.

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

About Us

"It's about Microsoft Excel"