Forum Discussion
Jingyu29
Jun 29, 2021Copper Contributor
Changing units of y-axis on histogram (Excel 2020 for Mac)
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...
HansVogelaar
Jun 29, 2021MVP
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.
- Jingyu29Jun 30, 2021Copper ContributorThat kind of doesn't make sense since I can do that for other types of graphs...
- HansVogelaarJun 30, 2021MVP
I agree, but that's the way it is... 😞