I have a fast change chart with expressions for 9 areas a target and a national view. The national view is an addition of the 9 areas so it going to be way up the Y axis. Therefor I have hidden it in the bar and line chart which is fine and it shows as I want in the straight table.
My problem is that if I select a CHO the Bar and Line chart show fine but if I have them unselected to show all nine then the Y axis will go up to the total of the National figure - see example attached.
Wondering if there is any way around this as apart from this it is doing what I need.
Screen shots attached
Any help would be appreciated