Best Way to Create Gantt with Milestone Markers?

slam

Well-known Member
Joined
Sep 16, 2002
Messages
817
Office Version
  1. 365
  2. 2019
Hi lovelies!

I'm using Excel 365.

Below is a mock-up of my data. Essentially, I want a Gantt Chart made up of the Start to End Date, then I want the Milestones placed as makers along the timeline bar.

Is this possible? I've tried the built in Line Charts, and I've tried the Online Gantt templates, but without success; maybe just haven't found the right one, or maybe I need an add-on?

NumberNamePhaseStart DateEnd DateMilestone 1Milestone 2Milestone 3Milestone 4Milestone 5
PJ00001Project ARealization12/01/202012/07/202107/01/2021
PJ00002Project BStabilization07/01/201906/30/202006/01/2020
PJ00003Project CRealization01/01/202108/31/202106/07/202107/12/2021
PJ00004Project DConcept05/01/201809/30/202107/01/2021
PJ00005Project EPreparation06/01/201909/30/2021
PJ00006Project FImplementation03/01/201912/31/202107/01/2021
PJ00007Project GRealization04/01/201912/31/202207/30/202006/21/202108/30/202108/31/202007/01/2021


Thank you so much!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
6,145
Office Version
  1. 365
Platform
  1. MacOS
heres a very old version I used to use as a template on various projects I used to run -

I put the word milestone into the list , so you may be able to adapt to suite your need
but before I do anything , is this the sort of thing you wanted?

 

slam

Well-known Member
Joined
Sep 16, 2002
Messages
817
Office Version
  1. 365
  2. 2019
Hi etaf,

Thanks. That's quite similar to what I'm looking for except I need the milestones on the same row. Essentially, each row is a separate project, and the milestones belong to one project only, so I'd want it to appear on the horizontal project timeline bar as a marker (diamond or something) where the milestone falls in the timeline. See image below for a mockup.

I'd have thought/hoped that a chart could do this, which would likely be easier than trying to achieve the equivalent with formulas/cells/rows/columns.

Thanks
 

Attachments

  • Example.JPG
    Example.JPG
    32.9 KB · Views: 44

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
6,145
Office Version
  1. 365
Platform
  1. MacOS
i dont know how to do with a chart, always used formulas
 

Forum statistics

Threads
1,175,824
Messages
5,899,686
Members
434,795
Latest member
tracid1987

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top