Rearrange scatter chart axes

[#1]

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

[Anonymous]

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))