Hi there,

I am trying to build a line chart which is based on a data set which will move over the time.

Basically, sometimes my source data will have 4 decimals, sometimes 3, sometimes 2, etc.

For example, on a set of data which will have a minimum of 1.3012 and a maximum of 1.4512, I would like an axis which goes from 1.30 to 1.4550.

Another example would be, if my data goes from 127.1 to 145.7, I want an axis going from 127 to 146.

My issue here is that the rule is not universal regarding the number of decimals. So first, I would say that I need a formula identifying the scenario (number of decimals) and then how I would like to round my extreme points (rounddown for minimum of the axis / roundup for max?)

Any help / thoughts would be much appreciated!

Thanks in advance