answersLogoWhite

0


Best Answer

It sounds like what you are trying to create is a Gantt chart. MS Project would be a better tool than MS Excel, but you can create a close approximation in Excel.

  1. Enter your data (task, start date, completed time units, and remaining time units).
  2. Create a stacked bar chart with your data.
  3. Modify the chart to look like a Gantt chart.

See related links for step-by-step details.

User Avatar

Wiki User

13y ago
This answer is:
User Avatar
More answers
User Avatar

Ishmael Usher

Lvl 2
2mo ago

hi

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you automatically draw an activity flow diagram given data in excel format with the list of activities and their order of execution and time taken for each activity?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Are there a graph to see the path of execution of code?

Sequence diagram (UML), activity diagram (UML), traditional flow chart (may be more...)


What is Activity-on-node?

Activity on node is a diagram where every node (circle) represents an activity.


Activity diagram for video rental system?

i knew how to draw the activity diagram fro video rental system but i dont know how to attach it here


How state Diagram are different from the Activity Diagram?

They are not as they both have the same features it just provides a better understanding when using one diagram in conjunction with the other. State machine diagram shows how state of some object or system could change, so transitions on the diagram are from one state to another state. Activity diagram shows set of actions and how one action could lead to another. In simple cases these diagrams might look like reverse of each other but in practice you need to select whether the diagram is about discrete number of states of some object or is it about organization of actions and activities possibly related to many different objects.


What is the purpose of an activity diagram?

The purpose of the activity diagram is to model the procedural flow of actions that are part of a larger activity. In projects in which use cases are present, activity diagrams can model a specific use case at a more detailed level. However, activity diagrams can be used independently of use cases for modeling a business-level function, such as buying a concert ticket or registering for a college class. Activity diagrams can also be used to model system-level functions, such as how a ticket reservation data mart populates a corporate sales system's data warehouse. Because it models procedural flow, the activity diagram focuses on the action sequence of execution and the conditions that trigger or guard those actions. The activity diagram is also focused only on the activity's internal actions and not on the actions that call the activity in their process flow or that trigger the activity according to some event (e.g., it's 12:30 on April 13th , and Green Day tickets are now on sale for the group's Copyright Rational Software 2003 http://www.therationaledge.com/content/sep_03/f_umlbasics_db.jspsummer tour). Although UML sequence diagrams can protray the same information as activity diagrams, I personally find activity diagrams best for modeling business-level functions. This is because activity diagrams show all potential sequence flows in an activity, whereas a sequence diagram typically shows only one flow of an activity. In addition, business managers and business process personnel seem to prefer activity diagrams over sequence diagrams -- an activity diagram is less "techie" in appearance, and therefore less intimidating to business people. Besides, business managers are used to seeing flow diagrams, so the "look" of an activity diagram is familiar. (reference by http://www.ibm.com/developerworks/rational/library/content/RationalEdge/sep03/f_umlbasics_db.pdf)


What is the difference between work flow and activity diagram?

hhhghg


What does seismographic mean?

A seismograph is a diagram that shows the activity of an earthquake. The longer the line on the diagram, the more violent the shaking of the ground is.


Which describes how to interpret the width of the bands in the mypyramid diagram?

Physical activity


Difference between activity diagram and dfd?

In data flow diagrams, the lines between "boxes" represent data that flows between components of a system. Because these only show the flow of data, they do not give an indication of sequencing.In activity diagrams, those lines are simply transitions between activities and do not represent data flow at all. They more represent the sequencing of activities and decisions. You can tell from these what order things happen in.


Explain with a neat diagram all possible states a process visits during the course of its execution?

Explain with diagram all possible states a process visits during the course of its execution New – The process created after a call from secondary memory. Ready – The process is loaded into the main memory for execution. Waiting – The process waiting to be allocated CPU time Executing – The process currently being executed


Er diagram of online railway reservation system?

try www.wikipedia.com which will help you for making ER - Diagram ....and copy past given link below in your browser for detailed description about ER - Diagram :http://www.infocom.cqu.edu.au/Courses/spr2000/95169/Extra_Examples/ERD.htm


What is the difference between activity diagram and sequence diagram?

Activity diagram shows the work flow from start point to the end point detailing many decision points. Sequence shows detail flow of specific use case and it also shows interaction between actors, system and system components