Detailed Squarified Treemap Heatmap
$30-250 USD
Paid on delivery
Hello,
I am interested in the R code for a specific project. I have data in excel that I export as a .csv to be opened in R. However, the programming in R is more advanced than I know. I would like to create a Squarified Treemap that sizes boxes based on ACB and color on return. The first level would be asset class. I would like the asset classes to have a colored border for each class. Within each asset class, there are multiple style categories. I would like the styles to have a dashed colored border. The final level is label. This is the box that is sized by ACB and color filled by return (dark red to dark green for + to -.) I would like a legend for border colors and a basic rectangle key for red/green with max/min values at ends. The label for each box should be level 3 and font scaled/rotated to fit in box.
Level 1: Asset Class, Level 2: Style, Level 3: Label, Box Size: ACB, Heat Color: Return
I have attached an example of the output I would like. I was unable to figure out the dashed style borders.
I can provide sample data to programmer once chosen.
Thanks!
I would also like an excel version with the code in VBA macro, doing all same things mentioned above.
Project ID: #6453162
About the project
Awarded to:
Hi, I have gone through your requirement of treemap graphs. R has some specific library for this. We can create this using Treemap library for R. I have 2.5 years work experience as a data analyst . Here is my li More