Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
I have a scatter chart, and eveytime I choose an option on a list box, or something like that, I would like to have the axes changed too, in order to capt the best view of those points in my chart.
How can I do it?
I think I have to change the MAX and MIN on the Scale tab of my chart.
But, what is the expression to do it?
Thanks for your attention
Best regards
Yes you are right you can use the Static Min and Static Max
What the expression should be depends on what you want
You can use:
=Min("Your Expression") for example =Min(sum(sales))
and
=Max("Your Expression") for example =Max(sum(sales))