Show middle hierarchy in Excel treemap?

Question

I have a CSV with filesystem data; file paths and size. I've created a treemap chart from this data, but the problem is that the treemap doesn't seem to take hierarchy into account. Each data point, no matter how deep in the hierarchy, is shown at the top level. I'd like it to appear more like the chart in WinDirStat/KDirStat, where each point is grouped hierarchically, by subfolders.

Full story: I'm trying to generate a chart like WinDirStat does, silently and from the command line. I have a PowerShell script that generates the CSV just fine. But if there's a better way, I'm open to it.

Answer 1

Data for the treemap chart (new in Excel 2016) must be arranged from broad to specific, left to right, each text value in its own column. Read more here.

The treemap charts are not as detailed as the WinDirStat visualisation, though.

Quoting from the Microsoft page:

Treemap charts are good for comparing proportions within the hierarchy, however, treemap charts aren't great at showing hierarchical levels between the largest categories and each data point.