SOLVED

Treemap Issues

Copper Contributor

Hi,

 

I am trying to create a treemap chart in Excel but for some reason it is not working as it should. 

Can you see from my screenshot what is wrong that is blocking me from creating a proper treemap?

As you can see, all of the line items are not being represented.

MollyR2154_0-1718955736149.png

 

5 Replies

@MollyR2154 

In the Select Data Source dialog, click Edit under Horizontal (Category) Axis Labels.

Change the range to ='BALANCE SHEET'!$A$1:$B$26

Click OK.

Then click Edit under Legend Entries (Series).

Change the range to ='BALANCE SHEET'!$C$1:$C$26

Click OK, then OK.

@HansVogelaar 

Thank you. Now it looks like this and the line items are still not being represented.

MollyR2154_0-1719146487859.png

 

best response confirmed by HansVogelaar (MVP)
Solution

@MollyR2154 

Difficult to say what's wrong in your model. Perhaps the attached file can help you resolve it. 

It contains an example with a similar structure and the chart comes out as it should.

Screenshot 2024-06-23 at 14.54.30.png

@MollyR2154 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Now it worked! Thank you!
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@MollyR2154 

Difficult to say what's wrong in your model. Perhaps the attached file can help you resolve it. 

It contains an example with a similar structure and the chart comes out as it should.

Screenshot 2024-06-23 at 14.54.30.png

View solution in original post