Create two Charts from one Pivot table - add multiple excel charts

How can I create multiple Pivot Charts from one Pivot table in Excel ?

Hi,

To create multiple pivot charts from one pivot table, you have to click on your pivot table:



Go to Analyze section in Pivot Table Tools:



Click on Pivot Chart and choose the Chart Type:



To add another pivot chart from the same pivot table, you have to repeat the chart creation process again and choose a different type of chart. You can also add multiple pivot charts by copy and paste functions, using Ctlr+C and Ctrl+V. Then you can click on the new chart with right mouse button and choose adifferent formatting.