
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there a way to show / hide a chart in a sheet with a button ?
Is there a way i can show or hide a chart in a particular sheet with a button ?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
You can add a calculation condition to the chart and use Button with variable. Here is an example:
1. Create a Table chart
2. Create a variable
3. Create a Button with configurations:
4. In Table chart go to Add-ons > Data handling > Calculation condition and set the value to: vHide='false'
5. Now when you click on the button it will check the value in the variable and will show or hide the data in the visualization.
NOTE: Natively hiding the entire chart is not yet supported as it will leave a blank space on the sheet. You can create an Container object with multiple visualizations and have the Tab disappeared when the button is clicked. This will leave you with less visualizations, rather than with empty blank spot. But if you want to hide the entire object after all, then you can submit a feature request [1].
Clicked once:
Clicked twice:
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
---

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
You can add a calculation condition to the chart and use Button with variable. Here is an example:
1. Create a Table chart
2. Create a variable
3. Create a Button with configurations:
4. In Table chart go to Add-ons > Data handling > Calculation condition and set the value to: vHide='false'
5. Now when you click on the button it will check the value in the variable and will show or hide the data in the visualization.
NOTE: Natively hiding the entire chart is not yet supported as it will leave a blank space on the sheet. You can create an Container object with multiple visualizations and have the Tab disappeared when the button is clicked. This will leave you with less visualizations, rather than with empty blank spot. But if you want to hide the entire object after all, then you can submit a feature request [1].
Clicked once:
Clicked twice:
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
---
