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

Question

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.

hansvogelaar · Answer

Jingyu29&nbsp;
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.

jingyu29 · Answer

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

hansvogelaar · Answer

Jingyu29&nbsp;
I agree, but that's the way it is... 😞

Forum Discussion

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

3 Replies

Resources