Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block Flow Diagrams
Hi,
I am an industrial chemist and I have a sophisticated spreadsheet for modelling chemical processes. I use Userforms and have a rudimentary knowledge of VBA. I use alot of macros and have found the advice on this website absolutely wonderful I am looking for a way to create a blockflow diagram from a chemical process that is listed on a sheet. Does anyone have advice or links that might be able to help me? Thanks in advance, Roger |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block Flow Diagrams
I think from your description to have a two step problem. Tbe first is to
break your formula into blocks. The second is to create shapes (what you call blocks) and place the shapes on the worksheet. I would start by using the Record macro feature (Tools - Macro Record Macro) and add the shapes to the worksheet and move the shapes in a fashion that meets your requirements. From this macro you can learn the techniques to create your block diagrams. Shapes have four properties you need to adjust 1) Top - pixel location of top edge 2) Left - pixel location of left edge 3) Width - number of pixels in horizontal direction 4) height - number of pixels in veticle direction You also may need to add lines. Lines also have four properties 1) X Start - in pixels 2) Y Start - in pixels 3) X End - in pixels 4) Y End - in pixels Arrows could be shapes or lines with pointed ends. "Roger on Excel" wrote: Hi, I am an industrial chemist and I have a sophisticated spreadsheet for modelling chemical processes. I use Userforms and have a rudimentary knowledge of VBA. I use alot of macros and have found the advice on this website absolutely wonderful I am looking for a way to create a blockflow diagram from a chemical process that is listed on a sheet. Does anyone have advice or links that might be able to help me? Thanks in advance, Roger |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block Flow Diagrams
Hi,
Can Jon' s brickyard chart be of any help ... ? http://peltiertech.com/Excel/Charts/Brickyard.html HTH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can excel print data flow diagrams of an existing excel database? | Excel Worksheet Functions | |||
How do I use excel to create process flow diagrams? | Excel Discussion (Misc queries) | |||
How do I label flow connectors in and excel flow chart? | Excel Discussion (Misc queries) | |||
Pie Diagrams | Charts and Charting in Excel | |||
Diagrams | Excel Discussion (Misc queries) |