Forum Discussion
How to create an Insurance Coverage Chart (Treemap?)
There's an ability to create treemaps in excel
Cheugy Thank you, but I've tried that and can't get it to do what I need. I need dollar amounts on the vertical axis, years on the horizontal axis, then boxes with company names to stack on top of each other so they line up with the years on the bottom and the amounts on the side (like the photo I attached).
Not sure if I'm just not setting it up correctly, but I tried changing data within the instructions from the link you provided, and it doesn't do it. 😞
- Can you send the raw data? I can take a stab at it
Sample attached. I need Amounts on the left axis, dates (years or quarter years) on bottom axis, then boxes for the policies to include name of insurance company, policy number, amount and specific date (although if I can just get name and policy number, I can add in other details after table is generated, I suppose). IDEALLY, each insurance company should have it's own color, but, of course, I can do that manually after the fact.
GOOD LUCK!!!!! HOPING YOU CAN FIGURE IT OUT!!!!
Hi ilenea
I think you stumped me on this one -_-
I reformatted the data and tried to replicate the treemap using stacked bar graphs. The overlaps and the large differences in pricing really made the data less meaningful. To visualize a value on y-axis and chronological x-axis, I think a scatter plot, heatmap, or line graph would be more meaningful and easier to do. I think with the current core functionality of excel, this wouldn't be possible without using a VBA script.
Maybe some other brain child on here can help, sorry, tried my best 😕 Good luck!