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

How can I create multiple Pivot Charts from one Pivot table in Excel ?
02 Mar 2021 at 06:01 PM
0pnshow more
NicoleNicole
Hi,

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

excel pivot table create multiple pivot charts

Go to Analyze section in Pivot Table Tools:

excel pivot table tools analyze

Click on Pivot Chart and choose the Chart Type:

excel pivot table create multiple pivot charts

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.

excel pivot table multiple pivot charts different type

06 Mar 2021 at 03:47 PM
0pnshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook & Twitter
2021 AnswerTabsTermsContact us