progress bar code in c# windows application Class 4 Chart Types in Microsoft Office

Printer Data Matrix in Microsoft Office Class 4 Chart Types

Class 4 chart types are useful for tracking and analysis of activities such as projects and processes We are all familiar with the concepts of the two class 4 chart types, which are the familiar Gantt chart and the milestone trend analysis (MTA) These charts are designed to depict information dealing with dates and times as they relate to the process and progress through a project and either hitting milestones and/or tracking variances from the milestones required One of the other areas in which I have some experience, the Finance module in SAP, has a fairly new component called the Financial Closing Cockpit One of its major charting components is the use of a Gantt chart to track the period closing process in finance or controlling The next illustration displays the initial configuration screen for a Gantt chart in the Chart Designer

and their substeps You can also group these substeps in categories The time is displayed on the X axis and the substeps and categories are displayed on the Y axis If you created categories, all substeps are displayed separately for each category on the Y axis You can display the time in days or you can use start and end times: Start Date Start Time End Date End Time All combinations of start and end points are supported: Start Date & End Date Start Date & Start Time & End Date Start Time & End Time If you select Start Time as the start point, the system uses the current data as the Start Date If you select Start Date or End Date as the start point or end point, the system fills Start Time and End Time with the value 0:00 This is particularly important for the interpretation of end points in the Gantt chart

6:

As with class 3 chart types, the construction of the data provider is the most important part of the process You build the table on which a Gantt chart is based as follows: The table must contain at least two data columns The first column determines the start point; the second column determines the end point In addition to the start points and end points, categories are also entered in the data columns You must make at least one entry (data column) for the start point and end point for each category An example of this type of query is displayed in the following illustration

01-25-2005

01-31-2005

02-20-2005

02-28-2005

03-20-2005

03-25-2005

03-15-2005

03-20-2005

03-25-2005

04-06-2005

03-01-2005

03-17-2005

02-26-2005

03-05-2005

03-01-2005

03-17-2005

03-15-2005

03-20-2005

03-25-2005

04-06-2005

The example illustrates a table for a Gantt chart; it contains three categories and no data for some start and end times The substeps are the Project Steps: Chart, Object Services, and Web Runtime The categories are the Work Packages: Concept Creation, Specification, and Solution Validation Once this information is applied to the Gantt chart type, the final result would be something similar to the display in the following illustration

30 31 1 2 3 4 5 6 7 8 9

21 22

28 1 2 3 4 5 6 7 8 9

21 22

31 1 2 3 4 5

In the example, the categories Concept Creation, Specification, and Solution Validation are displayed from bottom to top on the Y axis The substeps are included in accordance with the data in the underlying table, that is, only Chart and Web Runtime are included for the Concept Creation category because no data is specified for the Object Services substep The start point and end points for the substeps are displayed on the X axis (month, day)