Outrageous Add Milestones To Excel Chart

Create a standard chart with axes like a line or a bar chart.

Add milestones to excel chart. Set the Due Dates range as Series X values and the Efforts range as the Series Y values. In the dialog that pops up click on the Add button in the Legend Entries section. Create a Milestone Chart based on the data range 1.

Right-click on the scatter chart. In Excel 2007 and 2010 select the scatter chat and click the Layout Error Bars More Error Bars Options. What I am trying to do is somehow indicate milestones either as columns or otherwise automatically on this chart eg.

Click View and then in the Task Views group click Gantt Chart. In project management standards a milestone has no duration but we need a one day space for the diamond shape in the graph. I have a line chart showing Test Execution Progress.

The quickest way to create a milestone is to add a task with no duration to your project plan. After creating the miltestone chart click Kutools Charts Timeline Chart. I checked the milestones chart but did not work for me.

Then click the Select Data option. When builds are received etc. Creating the milestone chart Once your data is ready select the Dates and Values columns and create a chart by using the chart icons from the Insert tab of the Ribbon.

This is all fine. In Excel 2013 select the scatter chart and click the Design Add Chart Element Error Bars More Error Bars Options. Type the milestone name in the first empty row or pick a task you want to turn into a milestone.