Fast change charts with visible expression and Y axis

[rcorcoran]

Hi

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

Rhona

[rcorcoran · Accepted solution]

I found the answer to this myself.  I you set it to invisible on the axis tab and then set it to the top it will not show in the bar and line charts but will show in the straight table