Forum Discussion
Treemap Issues
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.
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?
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.
- Now it worked! Thank you!