Author Topic: Setting the color of a shape based on excel data  (Read 5987 times)

0 Members and 1 Guest are viewing this topic.

DC_Planner

  • Newbie
  • *
  • Posts: 3
Setting the color of a shape based on excel data
« 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

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Setting the color of a shape based on excel data
« Reply #1 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

DC_Planner

  • Newbie
  • *
  • Posts: 3
Re: Setting the color of a shape based on excel data
« Reply #2 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....

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Setting the color of a shape based on excel data
« Reply #3 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

DC_Planner

  • Newbie
  • *
  • Posts: 3
Re: Setting the color of a shape based on excel data
« Reply #4 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.

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Setting the color of a shape based on excel data
« Reply #5 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