How to Manage Tasks in an Attractive Milestone Chart in Your Excel Worksheet

Chart can reflect the schedules more intuitive in Excel. Hence, here we will show you the method of creating an attractive milestone chart in your worksheet.

Instead of showing data and the relating information in a chart, you can also input your schedules in a milestone chart. With this attractive chart, it will be hard for you to forget any of the tasks. The image below shows the test tasks of certain products.Example for Milestone Chart

And now we will use this example to show how to create such a milestone chart in your Excel worksheet.

Rearrange the Worksheet

Before you create the milestone chart in your Excel worksheet, you need first arrange the range.

  1. Click the cell C1 in the worksheet.
  2. And then input the content “Height” into the cell. This new column will be the height of the data series in the chart. Of course you can also input other contents according to your need.
  3. Now input a number into cell C2. Here we will input number “5” into this cell.

Here we input the number into a cell according to the importance of the task. You can also input a number into the cell according to your need.

  1. After that, continuing inputting other numbers for other tasks.New Column

When you finish the arrangement, your worksheet will be similar to this image.

Create the Milestone Chart

In this part, we will show you the steps of creating such a chart.

  1. Select the range A1:B6 in this worksheet. You need to select the first two columns in your actual worksheet.
  2. And then click the tab “Insert” in the ribbon.
  3. After that, click the button “Line” in the toolbar.
  4. Next select the option “Line with Markers”. Therefore, you have inserted a line chart into the worksheet.Insert Line Chart
  5. When the chart appears in the worksheet, the tab “Chart Tools” will also be activated. In this step, click the button “Select Data” in the toolbar.Select Data
  6. In the “Select Data Source” window, you can see that there are only one series in the list. Here click this series.
  7. And then click the button “Edit”.Edit
  8. In the “Edit Series” window, select the cell A1 for the “Series name”. You can also directly input the word directly into the text box.
  9. Next select the tasks for the “Series values”.Edit Series
  10. After that, click the button “OK” in this window.
  11. You will come back to the “Select Source” window. Now click the button “Add” in the window.Add
  12. Again you will see the “Edit Series” window. Here you need to input the “Text Tasks” into the first text box for the name.
  13. And then input the series values into the second text box. Here you need to select the column of “Height” that you have added.Second Series
  14. When you have finished the setting, click the button “OK”.
  15. In this step, click the button “Edit” in the “Horizontal Axis Labels”.Click Edit
  16. In the “Axis Label” window, input the date reference into the text box.Axis Label
  17. Next click “OK”.
  18. And here continue clicking “OK” in the “Select Data Source” window.
  19. Now in the chart, right click the series of “Test Tasks”.
  20. And then choose the option “Change Series Chart Type” in the menu.Change Type
  21. Next you will see the “Change Chart Type” window. Here choose the option “Column Chart” on the right.
  22. After that, click the button “OK”.Column
  23. In this step, still right click the same series.
  24. And then choose the option “Format Data Series” in the list.Format Data Series
  25. In the “Format Data Series” window, choose the option “Secondary Axis”.Second Axis
  26. And then close the window.
  27. Click the button “Select Data” in the toolbar.
  28. And then click the series of “Test Tasks” in the window.
  29. Here click the button “Edit” in the “Horizontal Axis Labels”.Click Edit
  30. In the “Axis Labels” window, select the tasks for the label.Select Tasks
  31. Next click “OK” in the “Axis Labels” window.
  32. And then continue clicking “OK” in the “Select Data Source” window.
  33. Click the tab “Layout” in the toolbar.
  34. And then click the button “Error Bars”.
  35. In the drop-down menu, choose the “More Error Bars Options”.Error Bars
  36. In the “Add Error Bars”, choose the series “Test Tasks”.
  37. And then click the button “OK”.Choose Series
  38. In the “Format Error Bars” window, choose the option “Minus” for the direction.
  39. Next change the amount into “Percentage”.
  40. After that, change the percentage into 100.Set Error Bar
  41. When you finish the settings, close this window.
  42. Next right click the “Test Tasks” series in the chart.
  43. And then still click the option “Format Data Series” in the menu.
  44. In the “Format Data Series” window, choose the option “No fill”.No Fill
  45. And then close this window.
  46. Next, delete the legend, gridlines, and two vertical axes in the chart. In addition, change the size of the chart according to your need.
  47. Here click the tab “Layout” in the ribbon.
  48. And then click the button “Data Labels” in the toolbar.
  49. Next choose the option “More Data Label Options”.Data Labels
  50. In the “Format Data Labels” window, check the option “Category Name” and the “Outside End” in the window.Label Options
  51. Then close this window.
  52. You will see that there are two types of data labels in the chart. Delete the labels for the “Date” series.

Now you have finished the modification of the milestone chart in your worksheet.Result

Besides, you can also make further modifications for this chart according to your need. And in this chart, all the tasks are listed clearly. Although there seems to be a lot of steps, the process actually is not so difficult.

Prepare Cash Outlay for Data Disaster

Data disaster is no longer far away from us nowadays. As a result, every Excel user will have the chance to meet with Excel corruption. In order to repair your Excel files, you will certainly need to prepare cash outlay beforehand. But now you can invest a third-party tool to repair your Excel files. This tool is able to repair Excel xlsx damage and retrieve your precious data and information from the damaged files. Thus, investing such a tool is necessary and worthwhile.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair Word data corruption and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.