Hello,
I have attached both Excel and PDF files. The Excel file contains an example of a schematic showing coverage layers for a layered insurance policy. The PDF contains a graphical depiction of the layering structure. (The PDF was originally created in Power Point)
My question is this. Is there a way to creat a "source schematic" in Excel and have it auto populate into an Excel graph such as the one seen in the PDF file? Having the sum of the shapes equal to 1, but sized based on their percentage of the total.
I need the user to be able to enter in any value, change colors, add/delete portions, etc., and have the changes apply to the resulting graph. There can be some defined source document limitations, but I need some flexibility with it.
The best I can come up with is using Tree Mapping, but the graphs are lacking cosmetically and you cannot change them.
Any ideas would be helpful. Do you know of a software program, website, etc.
Thanks all!
Regards,
John
Bookmarks