Forum Discussion
Treemap Issues
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.
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.
5 Replies
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.
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?
