Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a chart, with a single dimension, in which I would like to conditionally format the dimension column.
The condition is: If the two right characters of the dimension (named Node) are '00', it should be BOLD. Otherwise, normal characters.
Where (and how) should I write this condition?
Many thanks in advance!
Hi
Click the + sign next to the dimension (in the Dimension tab of the chart properties), select Text Format, and add the expression:
=If(Right(Node, 2) = '00', '<B>')
HTH
Jonathan
Hi,
Select that dimension,
Click on + symbol write expression in Text Format
Expression like
if(wildmatch(right(Node,2),'00',<B>)
Regards
Hi
Click the + sign next to the dimension (in the Dimension tab of the chart properties), select Text Format, and add the expression:
=If(Right(Node, 2) = '00', '<B>')
HTH
Jonathan