Skip to Content

Is there a way to use the Enable/Hide Show CHart Series at Runtime for a pie chart?

I have a pie chart, that has 3 pie pieces to it. I would like to allow my dashboard user to either click a check box or something and have the pie piece disapear from the chart showing the 100%, but of only the remaining two pieces.

I can do this on a bar chart in the Apperances - Layout tab, but i guess since the pie chart is not a series it is not letting me. is there a way?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 23, 2017 at 11:30 AM

    Hello,

    By default: not. But there is a trick to do this:

    You can set the pie chat color which you would like to hide the same as the background color to "hide". You can bind the color to the excel sheet, and you done. When you select the checkbox, you change the value of the binded cell to background.

    Regards,

    János

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 24, 2017 at 04:58 PM

    i'll give that a shot. thanks!

    Add comment
    10|10000 characters needed characters exceeded