在Excel2010中绘制简单的甘特图(国外英文资料).doc

在Excel2010中绘制简单的甘特图(国外英文资料) Then at the bottom of the dialog area will position axis is set to on the scale line, this set after secondary horizontal axis calibration position is consistent with the main horizontal axis. 6 add vertical line: again in group the currently selected content drop-down list, select 2011-10-18 series, and then click in the analysis group line and vertical line, at this time will add a chart with the current date (2011-10-18) position in the same vertical line. All landowners to add data labels: then click in the tag group data label - other data label options, set data label format dialog box appears, in the tags area to cancel value , and check the name series, to close the dialog. Since the series name is the current date, the series name added in the diagram is the current date. Revise the chart format and beautify the chart: Delete secondary horizontal axis on the chart, the secondary longitudinal axis, and adjust the data label to an appropriate location, such as the top of the vertical line, color, lines and modify the vertical line. Finally, it is necessary to modify the filling color of the series to beautify the diagram. Related articles In the Word table, the method for setting the data elevations XBMC sets Chinese tutorials The iPad adds the most detailed tutorial on fonts Use the Firefox Firefox bookmarks synchronization feature to facilitate the synchronization of books in different locations The page number method is set from page X in the Word document The Excel2010 line diagram adds the vertical line method Top 1: Excel classification axis introduction and production Next: a few ways to quickly enter data Label: EXCEL2010 tutorial excel [returning to the main page] [returning Excel tutorial] / [to join the three collections] [print] Guess you like The magic formula makes dynamic headers in Excel Excel daily experience skill Use Excel2003 as a method of multiplication tables Let the Excel graph be arbitrary and criss-cross