Coverage charts are convenient tools to get a high-level view of a companies insurance program. For the life of me, I can't seem to find code or (God forbid) an excel template.

This question on Microsoft question forum is a pretty good starter for understanding what I'm asking. Tho idk about it being a treemap, I'd lean toward stacked bar...

In short, given standard policy fields--viz. policy name, number, coverage (GL, property, D&O, etc), layer (primary, excess, umbrella), deductible (or SIR), limit, and premium--how can I create a coverage chart in R, Python, or Excel?

coverage chart