Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
311
Views
Topic starter
Hi All
I have noted in the forum that you can't do conditional formatting on a graph, is there another way you can hide the graph based on a cell value?
Cheers
Andrew
Posted : 21/05/2021 3:57 am
Hi Andrew,
You can add a condition to the formulas that build the data for your chart that hides it if a control cell meets the specified criteria. It won't hide the chart object, but it will hide the data in the chart.
It's difficult to explain, so I created a mock-up in the attached file.
Mynda
Posted : 21/05/2021 7:11 pm
