How does Excel make Gan Tetu pattern plate

Gan Tetu is a very useful tool in project management, can use at scheduling to mix dog plan.

Below the data that to in an attempt to shows 1 times is exemple, make a simple and practical Gan Tetu pattern plate.

Graph 1

Measure1: Click " insert " in option card " chart -- bar chart -- accumulation bar chart " , if the graph is shown 2 times, an empty chart is inserted in the job.

Graph 2

Measure2: Choose empty chart, be in " chart tool " option gets stuck " design " in option card, click data set to fall " choose data " , if pursue,3 are shown.

Graph 3

Measure3: Be in " choice data source " in the dialog box, click " add " pushbutton. Be in " editor data series " in the dialog box, the input is like the data that the graph shows 4 times:

Series name: Begin date

Series value: = Gan Tetu! $B$2:$B$12

Graph 4

Measure4: Be in again " choice data source " click in the dialog box " add " pushbutton, input the data that like the graph the place of 5 shows:

Series name: Last day of number

Series value: = Gan Tetu! $C$2:$C$12

Graph 5

Measure5: Be in " choice data source " in the dialog box, be in on the right side of " level (classification) axial label " below, click " editor " , if pursue,6 are shown.

Graph 6

Measure6: Be in " axial label " in the dialog box, choose all project name, if pursue,7 are shown.

Graph 7

Measure7: Present chart is shown 8 times like the graph. Noticing a project appear with contrary order.

Graph 8

Measure8: Click vertical reference axis, choose " format of setting reference axis " command. In " format of setting reference axis " " reference axis option " in choose " the category that disobey order " , if pursue,9 are shown.

Graph 9

Measure9: Right now, horizontal axis moved coping. Right attack horizontal reference axis, choose " format of setting reference axis " command. Be in " format of setting reference axis " in the setting that has is like a graph showing 10 times:

Graph 10

Measure10: So far, gan Tetu already got ready! If pursue,11 are shown.

Graph 11

Select blue series, the fill in setting series pattern is " without fill " , frame color is " without line " . Undertake to chart a few after decorating, if pursue,as a result 12 are shown.