Question

what is floor in chart area?​

Answer 1

Explanation:

In excel floor chart function is   given number down to the nearest specified multiple. FLOOR works like the MROUND function but FLOOR always rounds down.

Answer 2

The Excel FLOOR function is used to round a number down to a given multiple.

The multiple to use for rounding is provided as the significance argument by the user.

In this case, if the number is already an exact multiple, no rounding occurs and the original number is returned.

Explanation:

The Excel FLOOR function rounds a given number down to the nearest specified multiple.

It works like the ROUND function, but FLOOR always rounds down.

To format the chart floor one needs to first click on the chart floor to select it. And then right-click and select the Format Floor option from the resulting contextual menu,