I've always used your approach - aligning a shape graph next to a bar graph, so I'd be interested if anyone can combine the two.
To make "no change" disappear, you need to put Direction of change and Type of change on the colour shelf, then make "no change" white.
Brilliant and so simple!
It took me a minute to see how you "synchronized" the axis, but I got it. And the revised calc to help with the "no change" issue.
Appreciate the expert help!
1 of 1 people found this helpful
Thinking about it a bit more,
I suggest using a dynamic sync scale
instead of a fixed one (='the number').
The table calc for the scale looks like this:
TOTAL ( MAX ( [Value] ) ) * (1 + [Scale Parameter like 5% or 10%] )
And since it is a Table Calc, one should use
Compute using Table (Down) to align the figures.
Please find the revised workbook attached here.
Great solution - thanks again, Yuri!