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

How can I create multiple Pivot Charts from one Pivot table in Excel ?
posted on 02.03.2021 at 18:01
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

posted on 06.03.2021 at 15:47
0pnshow more
TimTim
share on facebookshare on twitter
2021 AnswerTabsTermsContact us