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

New Contributor

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.




3 Replies


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.

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


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