U ujjwal New Member Mar 12, 2013 #1 Hi all, I want to learn how to create Pivot chart using multiple Pivot tables. How to get dynamic maximum rows in each pivot table and so on. How to use formula in each row for creating chart and so on. Can anyone provide me any help or url. Thanks, Ujjwal Das Kolkata
Hi all, I want to learn how to create Pivot chart using multiple Pivot tables. How to get dynamic maximum rows in each pivot table and so on. How to use formula in each row for creating chart and so on. Can anyone provide me any help or url. Thanks, Ujjwal Das Kolkata
Luke M Excel Ninja Staff member Mar 12, 2013 #2 I'd recommend exploring Debra's site. She's considered one of the experts on PivotTables. Concerning dynamic sources, I'd start here: http://www.contextures.com/xlPivot01.html
I'd recommend exploring Debra's site. She's considered one of the experts on PivotTables. Concerning dynamic sources, I'd start here: http://www.contextures.com/xlPivot01.html