ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   multiple charts from a single pivot table (https://www.excelbanter.com/charts-charting-excel/256995-multiple-charts-single-pivot-table.html)

Yossi evenzur[_2_]

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

Luke M

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?


AdamV[_2_]

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?



All times are GMT +1. The time now is 07:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com