ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   is there a way of drawing floor plans within office (https://www.excelbanter.com/new-users-excel/81360-there-way-drawing-floor-plans-within-office.html)

madge

is there a way of drawing floor plans within office
 
is it possible to draw floor plans using office


WillR

is there a way of drawing floor plans within office
 
Sounds like a Job for MS Visio

One of the default template sets in Visio is for building plans, including
floorplans.


--
Kind Regards,
Will Riley


"madge" wrote:

is it possible to draw floor plans using office


CLR

is there a way of drawing floor plans within office
 
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



"madge" wrote:

is it possible to draw floor plans using office


madge

is there a way of drawing floor plans within office
 
thanx for info, but could you possibly tell me how to do it, very new user,
could do with step by step guide!

"CLR" wrote:

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



"madge" wrote:

is it possible to draw floor plans using office


madge

is there a way of drawing floor plans within office
 
just been looking for ms visio, but couldnt find it? any ideas where i can
find it?

"WillR" wrote:

Sounds like a Job for MS Visio

One of the default template sets in Visio is for building plans, including
floorplans.


--
Kind Regards,
Will Riley


"madge" wrote:

is it possible to draw floor plans using office


CLR

is there a way of drawing floor plans within office
 
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



"madge" wrote:

thanx for info, but could you possibly tell me how to do it, very new user,
could do with step by step guide!

"CLR" wrote:

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



"madge" wrote:

is it possible to draw floor plans using office


madge

is there a way of drawing floor plans within office
 
thanx very much i'll try that.

"CLR" wrote:

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



"madge" wrote:

thanx for info, but could you possibly tell me how to do it, very new user,
could do with step by step guide!

"CLR" wrote:

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



"madge" wrote:

is it possible to draw floor plans using office


CLR

is there a way of drawing floor plans within office
 
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



"madge" wrote:

thanx very much i'll try that.

"CLR" wrote:

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



"madge" wrote:

thanx for info, but could you possibly tell me how to do it, very new user,
could do with step by step guide!

"CLR" wrote:

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



"madge" wrote:

is it possible to draw floor plans using office



All times are GMT +1. The time now is 05:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com