Bar graph axes proportions

[#1]

Hi I want to know how to change the proportions of my bar graph so that the y axis always shows the target line.

Currently the max value of the biggest bar is 1.4mil however the target line is set at 1.75mil and the graph regardless of whether it is maximised will only show up to 1.4 mil.

Many thanks

[krishnacbe]

Hi,

You can use the Scales options for static Scale as shown in below image.

Regards

Krishnapriya

[sunny_talwar]

Have you tried using Static Max of may be 1.8 million?

[Anonymous]

You could put an expression in for Static Max.  Maybe 10% bigger than whichever is the largest of either or Target of your biggest bar.  This should then remain ok even when your data / targets change.

[#5]

Thanks Bill - I think this would be the best solution since the bars vary. What would this expression look like ?

[sunny_talwar]

May be something like this;

RangeMax(YourExpressionForBars, YourExpressionForTarget) * 1.10

RangeMax(Max(Aggr(YourExpressionForBars, YourChartDimensions)), YourExpressionForTarget) * 1.10

[#7]

Sorry to sound stupid but I have multiple bars so more than one expression. Will these simply all be inserted separated via comma ?

[sunny_talwar]

Yes within the RangeMax() function you can specify all different expressions (comma separated) and it will give you the max out of all the expressions.