View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Generating flowcharts from Excel Generating flowcharts from Excel is offline
external usenet poster
 
Posts: 1
Default Excel table to a flowchart

A solution to this problem alone will make Office worth the price for us.
We have a workflow in place. An Analyst will supply the QA group with a
visio diagram of the workflow, and the database developer with an excel file
of each status (decision box on the diagram) and each status available from
it.
For example, I can move work from a status of Open, to either Filed or
Pending. From Open, I need to have 3 statuses available, Open, Filed and
Pending. The spreadsheet woudl look something like this
Column 1 Column 2
Open Open
Open Filed
Open Pending

The Diagram is something like this:

Open ----Pending
|
|
V
Filed

Is there a way, some privately developed piece of code even, to take this
excel file and generate the diagram?

Because the analyst has to create the same work twice, they often miss a
status or two when updating a workflow with 8 or 9 steps.

Thanks, Sean