Multiple charts from same pivot table
adding multiple charts in from one pivot table. SQL Server > Power Pivot. I want to design 10 separate pie charts from 1 pivot table and use same slicer and filters for all. I can see an option to design 4- pivot charts under PowerPivot tab>PivotTable dropdown> 4 Pivot charts. Pivot Table with Multiple Sheets (Table of Content) Pivot Table with Multiple Sheets; How to Create Pivot Table from Multiple Sheets in Excel? Pivot Table with Multiple Sheets. Most of you know about the pivot tables, it is a very useful tool to get all your data consolidated in one table and get the figures for particular things as required. Which it is possible with one pivot chart because pivot is used the aggregate data and that data is going as source to chart. and you can use create two chart by copying one chart which has created by pivot and paste that chart. then right click on second newly pasted chart and choose change chart type then select your new type of chart which you want to apply.