H HanSam Member Oct 7, 2016 #1 Is it possible to create multiple doughnut charts from only one pivot table and show only specific series per doughnut? Say I want to show the different bu % per region on the file attached. Attachments Doughnut Sample.xlsx 15.1 KB · Views: 4
Is it possible to create multiple doughnut charts from only one pivot table and show only specific series per doughnut? Say I want to show the different bu % per region on the file attached.
Hui Excel Ninja Staff member Oct 7, 2016 #2 Add a chart Then add Business to the Filter section of the Pivot Table Fields You can now select the business directly on the chart or in the PT
Add a chart Then add Business to the Filter section of the Pivot Table Fields You can now select the business directly on the chart or in the PT
H HanSam Member Oct 7, 2016 #3 hi hui, Thanks for the response. However I need multiple doughnut charts to show at the same time. It would also include a filter that will control the contents of the PT, thus should reflect on the doughnut charts too
hi hui, Thanks for the response. However I need multiple doughnut charts to show at the same time. It would also include a filter that will control the contents of the PT, thus should reflect on the doughnut charts too
