Can we hide and show text boxes when fast change chart??

[#1]

Hi,

I have a chart which we can fast change between straight table and pivot. Now is there anyway to hide show text boxes when we change chart between straight and pivot table?

Thanks

[Anonymous · Accepted solution]

Only way I can think of to do that is to create two versions of the chart and then use a button to toggle hide and show the charts.  The triggers in the button could also hide show a supporting text box.

So, add a variable and toggle it between 0 and 1.  then go to each chart and add a conditional show based on the variable.

A discrete button will work like a fast change.

[roger_stone]

Can't think of a way of doing that because the Object ID is the same for each fast change chart/table/whatever. I think you would need to implement two charts as Mike says.