is there a way of drawing floor plans within office

  • Thread starter Thread starter Guest
  • Start date Start date
Sounds like a Job for MS Visio

One of the default template sets in Visio is for building plans, including
floorplans.
 
Yes, it is possible to draw Floor Plans in Excel.........I do it all the
time, and even use conditional formatting to color different elements
according to "Efficiency" or any other list of data required......they can
even be dynamic, contain drawing objects, and respond to macros if
desired.....very powerful tool!

hth
Vaya con Dios,
Chuck, CABGx3
 
thanx for info, but could you possibly tell me how to do it, very new user,
could do with step by step guide!
 
I don't know of anyplace that would have step-by-step instructions for
something like this. This is not what Excel is usually used for. I only use
it this way so I can make it into a dynamic reporting vehicle to
automatically read data off a list and color the different areas and or
machines, or other drawing objects thereon. I usually start by making all my
columns 1.71 wide, which gives me all "square" cells. This I designate as 1
square foot, and use cell borders to make the lines. This only is good for 1
foot resolution tho, so sometimes you may have to use a line from the Drawing
Toolbar. Images can be inserted. Text boxes can be used to annotate....etc,
etc. It takes a little practice.

hth
Vaya con Dios,
Chuck, CABGx3
 
thanx very much i'll try that.

CLR said:
I don't know of anyplace that would have step-by-step instructions for
something like this. This is not what Excel is usually used for. I only use
it this way so I can make it into a dynamic reporting vehicle to
automatically read data off a list and color the different areas and or
machines, or other drawing objects thereon. I usually start by making all my
columns 1.71 wide, which gives me all "square" cells. This I designate as 1
square foot, and use cell borders to make the lines. This only is good for 1
foot resolution tho, so sometimes you may have to use a line from the Drawing
Toolbar. Images can be inserted. Text boxes can be used to annotate....etc,
etc. It takes a little practice.

hth
Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
You're welcome Madge, and thanks for the feedback. Although the drawing part
is not really much touted as a "real" Excel feature, it can produce some very
exciting results. Good luck with your efforts, and post back if you have any
more questions.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top