News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Heat Map In Visio 2007 Using data from Excel

Started by deepakmalik, October 29, 2012, 11:27:45 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

deepakmalik

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


Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 151 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1058KB.
Tokens: post-login.
Cache hits: 13: 0.00118s for 26,766 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]