Friday, August 12, 2016

Trying out the new Excel 2016 Graph (Treemap)

Treemap with Office 2016:


Treemap with Google Docs (what this blog has used for a long time)

I have always used the Treemap feature in Google Docs to create my Portfolio rectangular breakdown of my stock weightings.

You can see the Treemap in the Portfolio page. I update it everytime I update the chart. http://www.youngdividend.com/p/portfolio_17.html

I have recently installed Microsoft Office 2016 and I notice they now have a Treemap feature! And it is quite nice. I gave it a spin and here is what I produced. They have a lot more fancier formatting options than Google Docs and I love the colors!

The one difference though is that Microsoft Office color codes each sector with their own color. In the Google Docs treemap I have been using for more than a year, I used colors to indicate if a position was more speculative (red) or safe (green). I haven't figured out how to color code it that way and also have it group the sectors together.

I'll post a tutorial soon on how you can make your own graphs like this shortly!

5 comments:

  1. Hi Young Div,
    The new treemap looks pretty cool to me - easier and much cleaner to read. Thanks for sharing.

    MG

    ReplyDelete
  2. Excel is being actively used by business professionals in several types of routine functional business tasks.salesforce datawarehouse

    ReplyDelete
  3. Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. Microsoft Excel Training Courses Malaysia

    ReplyDelete
  4. Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work. convert psd to wordpress theme

    ReplyDelete
  5. After going over a handful of the weblog articles on your internet site, I really respect your method of writing a weblog. I bookmarked it to my bookmark webpage listing and might be checking lower back in the near destiny. Please test out my website as well and let me understand what you web watched.

    ReplyDelete