Visio Guy

Visio Guy Website & General Stuff => Data Visualization & General Graphics Topics => Topic started by: deepakmalik on October 29, 2012, 06:27:45 PM

Title: Heat Map In Visio 2007 Using data from Excel
Post by: deepakmalik on October 29, 2012, 06:27:45 PM
Hi

Can some one please advise on how to link excel data to visio shapes...
Basically i am trying to generate a heat map..

I have got a visio structure (very basic, just set of linked squares) i want to colour those boxes based on the status of items in those box in an excel file...

For example..

The box in visio file says X PLan
In the excel file the Status of the X Plan is submitted

I want to have the box coloured as Yellow

Now the status of X plan in Approved
I want the colour of the box to be Green

Note: I am using visio 2007
Title: Re: Heat Map In Visio 2007 Using data from Excel
Post by: Jumpy on October 30, 2012, 02:58:01 AM
Crosspost:

http://visguy.com/vgforum/index.php?topic=3421.msg16882;topicseen#msg16882