Changing units of y-axis on histogram (Excel 2020 for Mac)

[Jingyu29]

I couldn't find where to change the units of the vertical axis when creating a histogram (e.g. changing 0 20 40... to 10 20 30.... in the example below).

I am able to do it easily at the format axis tab when creating other types of graphs. Also, in Excel 2016 I was able to change it under format axis -> display unit.

I'm currently using Excel 2020 for mac.

[#2]

@Jingyu29 

Histogram charts don't support custom display units, as far as I can tell. Trying to set a custom display unit in VBA results in an error.

[#3]

That kind of doesn't make sense since I can do that for other types of graphs...

[#4]

@Jingyu29 

I agree, but that's the way it is... :(