Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: DC_Planner on May 11, 2009, 12:06:12 PM

Title: Setting the color of a shape based on excel data
Post by: DC_Planner on May 11, 2009, 12:06:12 PM
Hello all,

New here and still doing searches to maybe find this somewhere.  Google was not helpful here.  But I decided to post to see if someone can help me get this moving.

I have a floor plan of a data center.  Lots of rectangles all on a layer showing cabinets. I need to be able to set the color of a shape based on a number in a excel spreadsheet.  It will be closed and most likely closed.  I do not mind a data import from a closed file as a step to keep the data refreshed as long as I can pull from the "live" data when I need to.

I would like this to be a separate layer which i can take care of duplicating the current shapes.  For the reason that I can turn it on or off depending who I am presenting to.  The number I am referring to can be anything from 0-35 and I would like it to be based on 4 colors.

Any help will be nice.

Thanks all

DCPro
Title: Re: Setting the color of a shape based on excel data
Post by: aledlund on May 11, 2009, 12:31:16 PM
As a point to consider, link the shapes to the excel spreadsheet and then do a color by value. Requires v2007 pro...
http://office.microsoft.com/en-us/visio/HA100518191033.aspx
al
Title: Re: Setting the color of a shape based on excel data
Post by: DC_Planner on May 11, 2009, 02:07:15 PM
OK I have been looking for these screen and I think it may be a version issue.  Here is the screen shot.  Can someone confirm if this is the PRO version or not.

Thanks for the sanity check....
Title: Re: Setting the color of a shape based on excel data
Post by: aledlund on May 11, 2009, 06:01:13 PM
That's always given me a headache as well. I usually just check the menu (Data) to see if "Display Data On Shapes" is there and enabled.
al
Title: Re: Setting the color of a shape based on excel data
Post by: DC_Planner on May 11, 2009, 07:22:29 PM
I do not have that menu selection.  So I am guessing that means I cannot link shapes to Excel Data, or I need to talk my boss into spending money for everyone to have this feature?

ERRR....

so is there any other way to do a conditional formatting of a cell?  I would even be willing to enter shape data if it will color the cell correctly.
Title: Re: Setting the color of a shape based on excel data
Post by: aledlund on May 11, 2009, 10:30:22 PM
check "tools=>add-ons=>map and floor plans=>color by value" as one scenario the second would be to have different layers with different attributes and move the shapes between the layers.
al