Page 290 - DMGT206_PRODUCTION_AND_OPERATIONS_MANAGEMENT

Unit 14: Operations Scheduling

2. On the Patterns tab of the Format Data Series dialog box, click None for Border and None Notes
for Area, and then click OK.
3. Double-click the category (x) axis, which in a bar chart is the vertical axis. (In a bar chart,
the traditional x and y-axes are reversed.) Click the Scale tab, and select the Categories in
reverse order check box.
4. Click the Font tab, click 8 under Size, and then click OK.
5. Double-click the value (y) axis, which in a bar chart is the horizontal axis. After completing
the last step, this axis should be located at the top of the chart plot area. Click the Scale tab
and type the following values3 in the appropriate boxes: Minimum: 36739; Maximum:
37441; Major unit: 61; Minor unit: 1.
6. Also on the Scale tab, select the Category (X) axis crosses at maximum value check box.
7. Click the Alignment tab, and under Orientation, type 45 in the Degrees box.
8. Click the Font tab, and under Font style, click Bold. Under Size, click 8, and then click OK.

9. Right-click the legend, and click Format Legend on the shortcut menu.
10. Click the Placement tab, and click Bottom.
11. Within the legend, click Start Date so that it is selected, and then press DELETE.
After completing these steps, you should have a chart that looks similar to the example in Figure
below. You may need to resize the chart using the mouse to see all the labels present in the chart.
Additional formatting can be added as needed.
What has been described is for a simple project. Ideally, tasks in simple projects would not go
beyond a single page, which makes them manageable. Often, and especially in complex
manufacturing schedules, each task may be broken into smaller and more easily manageable
subtasks. These subtasks may be moved to subordinate charts, with their own timelines.

Did u know? What is Work Breakdown Structure?

In management terminology, the process – of breaking up of these tasks into independent
unit-tasks that can be completed on their own – has been given an exotic name of WBS, or
‘Work Breakdown Structure’.
Figure 14.3: A Gantt Chart Made using MS Excel

LOVELY PROFESSIONAL UNIVERSITY 285