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

%3CLINGO-SUB%20id%3D%22lingo-sub-2498724%22%20slang%3D%22en-US%22%3EChanging%20units%20of%20y-axis%20on%20histogram%20(Excel%202020%20for%20Mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2498724%22%20slang%3D%22en-US%22%3E%3CP%3EI%20couldn't%20find%20where%20to%20change%20the%20units%20of%20the%20vertical%20axis%20when%20creating%20a%20histogram%20(e.g.%20changing%200%2020%2040...%20to%2010%2020%2030....%20in%20the%20example%20below).%3C%2FP%3E%3CP%3EI%20am%20able%20to%20do%20it%20easily%20at%20the%20format%20axis%20tab%20when%20creating%20other%20types%20of%20graphs.%20Also%2C%20in%20Excel%202016%20I%20was%20able%20to%20change%20it%20under%20format%20axis%20-%26gt%3B%20display%20unit.%3C%2FP%3E%3CP%3EI'm%20currently%20using%20Excel%202020%20for%20mac.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jingyu29_1-1624995660855.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292396iF70DA279FD31303C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Jingyu29_1-1624995660855.png%22%20alt%3D%22Jingyu29_1-1624995660855.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2498724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2499012%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20units%20of%20y-axis%20on%20histogram%20(Excel%202020%20for%20Mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2499012%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1091312%22%20target%3D%22_blank%22%3E%40Jingyu29%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHistogram%20charts%20don't%20support%20custom%20display%20units%2C%20as%20far%20as%20I%20can%20tell.%20Trying%20to%20set%20a%20custom%20display%20unit%20in%20VBA%20results%20in%20an%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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...