Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I set the Static min, Static Max and Static Step for Bar chart. please can anyone suggest me.
Thanks.
Please see attached.
Properties -> Axes -> Static Min/Max
Voila.
Thanks. Sorry I know the location, but actually I need the values to type in Static Min, Static Max and Static Step? Please help
Hi Amelia,
Chart Properties - > Axes-> Scale -> Static Min / Max/ Step
Don't forget use number between 0 and 1 when work with percents.
To work wih Static Min correctly uncheck "Forced 0"
Kind regards,
Andrei
Thanks. Can I give the same values if I have two more expressions?
The values you need strongly depend on how you want to limit your axes. If 100% is your limit then you use 1.
Yes, you can
Also instead of static numbers you can use an expressions:
=max(Expression1)
=min(Expression1)
Pls check attached file.