Author Topic: Create an Excel Tree Map in Visio  (Read 5705 times)

0 Members and 1 Guest are viewing this topic.

rlntel

  • Newbie
  • *
  • Posts: 9
Create an Excel Tree Map in Visio
« on: August 29, 2015, 07:26:19 AM »
Hello,

I've been tasked with creating a tree map to identify how much money is allocated to different projects within our different business verticals. Basically, the are four different columns and inside each are larger and smaller squares (relative to how many dollars they represent).

Apparently, this is pretty easy to accomplish with Excel - you just install a free treemap add-in and connect the treemap chat to the data.

(See attachment)

Unfortunately, my organization operates on a closed network where every new software request is heavily vetted. I'm on a short suspense so a long wait to get Excel Treemap approved and loaded won't work.

I do have Visio 2010, though. Is there a way to do this in Visio?

Can't find anything on the Web. Help is greatly appreciated.

Thanks in advance.
« Last Edit: August 29, 2015, 09:27:46 AM by rlntel »

Yacine

  • Hero Member
  • *****
  • Posts: 2703
Re: Create an Excel Tree Map in Visio
« Reply #1 on: August 29, 2015, 03:03:26 PM »
You'll probably not find a free solution for Visio.
It will be cheaper to buy the Excel addin.
And coding it by yourself - whilst very challenging - looks very difficult at a first glance
Google "Treemap Algorithm".
Yacine

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3817
  • Ideas Visio-lized into solutions
Re: Create an Excel Tree Map in Visio
« Reply #2 on: August 29, 2015, 03:09:43 PM »
I agree with Yacine...a lot of coding!

As an unrequested 2 cents worth, I think that diagram style is one of the worst for conveying information in a meaningful, understandable, quantifiable manner.

Wapperdude
Visio 2019 Pro

rlntel

  • Newbie
  • *
  • Posts: 9
Re: Create an Excel Tree Map in Visio
« Reply #3 on: August 29, 2015, 03:20:05 PM »
Disregarding opinions and keeping in mind the fact that the requirement comes down from echelons above me, I'm surprised that Visio, Microsoft's data diagramming tool, cannot do what Excel, Microsoft's primary math tool, can.

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3817
  • Ideas Visio-lized into solutions
Re: Create an Excel Tree Map in Visio
« Reply #4 on: August 29, 2015, 03:58:42 PM »
Sorry.  I do realize the format wasn't your choice. 

Excel is much more than a math program.  Visio is more of a graphic display tool with added in data linking.

Unfortunately, your options are dwindling rather rapidly and your management needs to come to grips with reality...

1) there's no existing Visio solution that I've encountered.  You may give David Parker a try.  He does a lot with Visio and data management.  I believe his website is http://blog.bvisual.net/

2) expedite purchasing the Excel add-in.  Any chance of an evaluation copy?

3) understand that a custom code solution will require a lot of time

4)  accept a different format...a progressive bar chart for each business sector could be very effective.  Each sector is represented by a bar that is sub-divided projects.  The total bar length represent total allocations, each sub represents project allocations.  Would be simple and effective.

Probably not what you want to hear, but I think those are your choices.

Wapperdude
Visio 2019 Pro

rlntel

  • Newbie
  • *
  • Posts: 9
Re: Create an Excel Tree Map in Visio
« Reply #5 on: August 29, 2015, 04:57:14 PM »
Thanks for the honesty.

Actually, the Excel Treemap add-on is free. It's just the unavoidable time delay while it's being vetted, we're trying to get around.

Oh well...I'll give Parker's site a try. Thanks.

Yacine

  • Hero Member
  • *****
  • Posts: 2703
Re: Create an Excel Tree Map in Visio
« Reply #6 on: August 30, 2015, 05:35:40 AM »
... I'm surprised that Visio, Microsoft's data diagramming tool, cannot do what Excel, Microsoft's primary math tool, can.
Obviously Excel can't neither. You need an addin to do the job.
Same for Visio - MS did not supply this diagram type with the standard package, but one could write an according addin. Alas Visio is not so wide spread as Excel is.

I nontheless agree with you so far, that more diagram types in visio would be very nice to have.
Yacine