![]() In the Select Data Source dialog, select Activity, then click Edit button in the Horizontal (Category) Axis Labels section.ġ6. Close the dialog, then right click on the chart to select Select Data from context menu.ġ5. In Excel 2013, just directly type the number into the text boxes beside Minimum, Maximum and Major.ġ4. ![]() In the Axis Options section of Format Axis dialog, check Fixed options beside Minimum, Maximum and Major unit, then type -6, 6 and 2 in each text box. Right click on the primary axis (the left one), and select Format Axis from context menu.ġ3. In Excel 2013, check Secondary Axis option under Series Options section in the Format Data Series pane.ġ2. Check Secondary Axis option in the Series Options section. Right click on the columns and select Format Data Series from context menu.ġ1. In Excel 2013, click All Charts > Combo, and go to Activity series and select Clustered Column chart from the drop down list of Chart Type, and click the OK button.ġ0. Then select Clustered Column chart in the Change Chart Type dialog. ![]() Then right click on any data point in the Activity series (the red one), and click Change Series Chart Type from context menu. Click OK, go back to Select Data Source dialog, and click Add button again, and select Activity as the Series name and the data below Text Placement as Series values in Edit Series dialog. Click OK to go back to Select Data Source dialog, click Edit button in the Horizontal (Category) Axis Labels section, and then select data below Month as Axis label range in the popping Axis Labels dialog. In the popping Select Data Source dialog, click Add button to open Edit Series dialog, then select Month as Series name, and the data below Activity as the Series values. Right click on the blank line chart to show the context menu, and click Select Data.ĥ. ![]() Click Insert > Line > Line with Markers to insert a blank line chart. In the Text Placement column, type 5 into the second cell, cell C2, then type -5 into the third cell, cell C3, and repeat type 5 and -5 into the below cells. Type Text Placement into the next column to the base data, see screenshot:Ģ. Now let’s begin to create a milestone chart.ġ. Now this tutorial is talking about the steps to create a milestone chart in Excel.Ĭreate Milestone chart with 3 steps by a handy toolįor instance, your project process is as below screenshot show: How to create a timeline milestone chart in Excel?Ī milestone chart is an effective tool to depict a project’ scope and timelines. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |