How does Excel determine axis values ​​for charts?

Question

When Excel determines the axis values ​​that will be used to represent your data in a chart, the values ​​are "evenly distributed."

For example: If you draw the following line in the Excel chart ruler. [0.22,0.33,0.44,0.55,0.66,0.77,0.88,0.99,1.1,1.21,1.32,1.43,1.54,1.65,1.76,1.87,1.98,2.09,2.2] Excel determines that the values ​​of the Y axis must be [0 , 0,5,1,1,5,2,2,5].

What method or formula is used to determine these values?

Answer 1

Please take a look at:

Intelligent, optimized map scaling

and

Algorithm for "nice" grid intervals on a graph

, .

Answer 2

, Excel:

1) Y, ,

2) Y

3) - ​​ "" (.1,.2,.5, 1, 2, 5, 10, 50, 100 ..), . , 5 10 , .