Detailed Squarified Treemap Heatmap

In Progress Posted Sep 14, 2014 Paid on delivery
In Progress 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.

Java R Programming Language Visual Basic

Project ID: #6453162

About the project

3 proposals Remote project Active Sep 16, 2014

Awarded to:

arpankumarde

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

$83 USD in 3 days
(0 Reviews)
0.0

3 freelancers are bidding on average $84 for this job

rebxguarina

A proposal has not yet been provided

$80 USD in 3 days
(0 Reviews)
0.0
ameeksingh

A proposal has not yet been provided

$88 USD in 3 days
(0 Reviews)
0.0