answersLogoWhite

0

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

15y ago

What else can I help you with?

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 the purpose of an activity node diagram and how can it be used to represent the flow of activities in a process?

An activity node diagram is used to visually represent the sequence of activities in a process. It helps to show the flow of tasks, decisions, and interactions within a system. By using nodes to represent activities and connecting them with arrows to show the order of execution, the diagram provides a clear and organized way to understand the steps involved in a process. This visual representation can help stakeholders identify bottlenecks, optimize workflows, and improve efficiency in a process.


What is an activity-on-node diagram and how is it used in project management?

An activity-on-node diagram is a visual representation of project tasks and their dependencies. It is used in project management to show the sequence of activities and their relationships, helping to plan and schedule tasks efficiently.


What is Activity-on-node?

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


How can I use an activity on node diagram generator to create a visual representation of a project's workflow?

To create a visual representation of a project's workflow using an activity on node diagram generator, you can input the tasks or activities involved in the project and their relationships or dependencies. The generator will then create a diagram showing the flow of tasks, their sequence, and any parallel activities. This visual representation can help you understand the project's workflow, identify critical paths, and optimize task sequencing for efficiency.


What is the relationship between the duration of each activity on an arrow diagram and the overall project timeline?

The duration of each activity on an arrow diagram directly impacts the overall project timeline. Longer durations for activities can delay the project timeline, while shorter durations can help speed up the project completion. It is important to carefully manage and monitor the durations of activities to ensure the project stays on track and meets its deadlines.


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