Forum Discussion

Anonymous's avatar
Anonymous
Apr 20, 2018

Treemap Issues

Hello, I am trying to build treemap graphs for a presentation that will be in PowerPoint. I know that I am not using the chart function exactly as planned but am hoping someone can help. I have cr...
Charts & Visualizing Data
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 20, 2018

Hi Amanda,

 

Could you share this sample file to check?

Anonymous's avatar
Anonymous
Apr 20, 2018

I actually created this in PowerPoint chart feature so the excel file I captured in my original post is the data that was entered.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 20, 2018

    When your PowerPoint file with this sample

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 23, 2018

        Hi Amanda,

         

        Thank you for the files. It looks like the reason is what Treemap doesn't show data correctly if you have zero values in the middle of the list. The workaround could

        - if you prepare data in Excel to sort the list in descending order moving zeroes to the bottom of the list;

        - if directly in PowerPoint move all zeroes to the bottom manually. You may copy/paste all zero records to the bottom and in the middle repeat any non-zero record at that place. Repeating records affects nothing in Treemap. Like this

        and in attached file.

Resources