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.

 

Jingyu29_1-1624995660855.png

 

3 Replies

@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.

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

@Jingyu29 

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