Skip to Content
0

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

Jan 16, 2017 at 02:04 PM

40

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Janos Nagy
Jan 23, 2017 at 11:30 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Keith Blanco Jan 24, 2017 at 04:58 PM
0

i'll give that a shot. thanks!

Share
10 |10000 characters needed characters left characters exceeded