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

How can I create multiple Pivot Charts from one Pivot table in Excel ?
0
give a positive ratinggive a negative rating
02 Mar 2021 at 06:01 PM
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

0
give a positive ratinggive a negative rating
06 Mar 2021 at 03:47 PM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
Follow us on Facebook
2022 AnswerTabsTermsContact us