Excel treemap not showing in ribbon or anywhere ...

%3CLINGO-SUB%20id%3D%22lingo-sub-1423213%22%20slang%3D%22en-US%22%3EExcel%20treemap%20not%20showing%20in%20ribbon%20or%20anywhere%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423213%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EApologies%2C%20I'm%20a%20relatively%20new%20excel%20user.%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20treemap%2C%20however%20I%20can't%20seem%20to%20find%20the%20option%20anywhere.%20Does%20anyone%20know%20how%20I%20can%20access%20it%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-05-28%20at%207.46.35%20pm.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194982i3F7703359E81E43D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screen%20Shot%202020-05-28%20at%207.46.35%20pm.png%22%20alt%3D%22Screen%20Shot%202020-05-28%20at%207.46.35%20pm.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1423213%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423271%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20treemap%20not%20showing%20in%20ribbon%20or%20anywhere%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423271%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F682062%22%20target%3D%22_blank%22%3E%40ImogenR%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMS%20support%20pages%20list%20the%20following%20Excel%20for%20Mac%20versions%20that%20support%20treemap.%20Which%20version%20are%20you%20using%3F%3C%2FP%3E%3CH1%20id%3D%22toc-hId-468310802%22%20id%3D%22toc-hId-468310802%22%20id%3D%22toc-hId-468310802%22%20id%3D%22toc-hId-468310802%22%20id%3D%22toc-hId-468310802%22%3ECreate%20a%20treemap%20chart%20in%20Office%3C%2FH1%3E%3CDIV%3E%3CDIV%20class%3D%22appliesTo%22%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20Microsoft%20365%20for%20Mac%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202019%20for%20Mac%2C%3C%2FSPAN%3E%26nbsp%3B%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202016%20for%20Mac.%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423285%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20treemap%20not%20showing%20in%20ribbon%20or%20anywhere%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423285%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Riny%2C%20thanks%20for%20responding.%20I%20have%20an%20office%20365%20subscription.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423314%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20treemap%20not%20showing%20in%20ribbon%20or%20anywhere%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F682062%22%20target%3D%22_blank%22%3E%40ImogenR%3C%2FA%3E%26nbsp%3BThis%20is%20how%20it%20looks%20for%20me%20in%20O365%2C%20also%20on%20a%20Mac.%20Not%20quite%20the%20same%20as%20yours.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-05-28%20at%2012.26.48.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194985i8DC1F582AB8C7AB1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202020-05-28%20at%2012.26.48.png%22%20alt%3D%22Screenshot%202020-05-28%20at%2012.26.48.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423367%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20treemap%20not%20showing%20in%20ribbon%20or%20anywhere%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423367%22%20slang%3D%22en-US%22%3E%3CP%3ENope%2C%20not%20the%20same%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20.%20I'm%20just%20checking%20for%20updates%20manually%20(I%20thought%20I%20had%20set%20it%20to%20automatically%20update%2C%20but%20looks%20like%20I%20was%20wrong).%20This%20is%20probably%20something%20I%20should%20have%20done%20before%20posting%20here%20...%20fingers%20crossed%20updating%20and%20restarting%20will%20fix%20the%20issue.%20Thanks%20for%20your%20time%20and%20help%20Riny.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

Apologies, I'm a relatively new excel user.

I'm trying to create a treemap, however I can't seem to find the option anywhere. Does anyone know how I can access it?

Screen Shot 2020-05-28 at 7.46.35 pm.png

4 Replies
Highlighted

@ImogenR 

MS support pages list the following Excel for Mac versions that support treemap. Which version are you using?

Create a treemap chart in Office

Excel for Microsoft 365 for Mac, Excel 2019 for Mac, Excel 2016 for Mac.
 
Highlighted

Hi Riny, thanks for responding. I have an office 365 subscription. @Riny_van_Eekelen

Highlighted

@ImogenR This is how it looks for me in O365, also on a Mac. Not quite the same as yours.

Screenshot 2020-05-28 at 12.26.48.png

Highlighted

Nope, not the same @Riny_van_Eekelen . I'm just checking for updates manually (I thought I had set it to automatically update, but looks like I was wrong). This is probably something I should have done before posting here ... fingers crossed updating and restarting will fix the issue. Thanks for your time and help Riny.