• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

doughnut chart help

H

HanSam

Member
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
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

upload_2016-10-7_13-54-29.png
 
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
 
You must log in or register to reply here.
Back
Top