Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have put text in a bar chart at the end of the bars (its horizontal), but the problem is when I click on a bar, all the stays in place and ruins the look of the chart. I am just wondering if there is a way to get rid of the text in chart when I click on a bar, but bring it back when I clear my selections?
Hi,
sure. Your chart follows some dimension surely. That is a field you can refer to. So in the edit_field for your text, just insert an IF_construct with the GetselectedCount() function to identify whether that field has been selected on - which is the case when the bar has been clicked on.
=> Sth like >> IF(Getselectedcount([dimension_field]) >= 1,' ', '[text]') <<
=> That way, when one of the bar in your chart has been clicked, that text would be empty. (don't forget to put a transparent background to your text)
HTH
Best regards,
DataNibbler
Hi,
sure. Your chart follows some dimension surely. That is a field you can refer to. So in the edit_field for your text, just insert an IF_construct with the GetselectedCount() function to identify whether that field has been selected on - which is the case when the bar has been clicked on.
=> Sth like >> IF(Getselectedcount([dimension_field]) >= 1,' ', '[text]') <<
=> That way, when one of the bar in your chart has been clicked, that text would be empty. (don't forget to put a transparent background to your text)
HTH
Best regards,
DataNibbler