Create a Basic Gantt Chart with Milestones Markers




About this tutorial:

Video duration: 12:36
🔔 SUBSCRIBE to my channel ➜

If you created gantt charts you know it a great visual tool to see how different tasks are scheduled compared to each other. What may also be nice is to see how this list of task or activities compare in relation to some milestones. You can manually create milestone markers by using the drawing tools in Excel, but another way to do this is how have another chart element (scatter chart with lines) to draw out the milestone markers. The added benefit is that it is dynamic; if your chart changes or you need to change the milestone…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

12 thoughts on “Create a Basic Gantt Chart with Milestones Markers

    Doug H

    (February 17, 2020 - 3:13 pm)

    Eric Tsang

    (February 17, 2020 - 3:13 pm)

    Dong
    no idea why ,but copy and past the Milestone figure on the chart, it does not always work!

    James Snikeris

    (February 17, 2020 - 3:13 pm)

    Doug,

    When I add the first Milestone, everything appears to look correct in the preview, but when I hit ok, excel flips the x and y axis and the whole gantt chart gets messed up. Could you help with this?

    Thank you

    sosoboss

    (February 17, 2020 - 3:13 pm)

    Hi, thank you for the tutorial, it's very helpful. However, I would like to make a Gantt Chart to compare two methods for a project. Do you think it's possible to show for each tasks the time it's took with method 1 and method 2 ?

    blah blah

    (February 17, 2020 - 3:13 pm)

    I am facing the same problems Mark and Kushan have referred to here. I am able to edit the first milestone with no issues up to the point where i have to copy and paste the 2nd range of data into the chart. As soon as i copy and paste the 2nd marker ranges, I think (could be wrong here) excel assumes we are trying to connect the end point of previous marker with the start of 2nd marker. The end result is I get a " N " shape connecting the 2 markers rather than two milestone bars " I I ". Any help would be appreciated. Thanks!

    Ashok Kandukury

    (February 17, 2020 - 3:13 pm)

    Simple and sweet..

    Soumi Sur

    (February 17, 2020 - 3:13 pm)

    How is copy pasting the value including the series withing the gantt chart value?

    kushan Samarasinha

    (February 17, 2020 - 3:13 pm)

    As Mark has highlighted i'm having the same problem & appreciate if you could guide on this

    kushan Samarasinha

    (February 17, 2020 - 3:13 pm)

    Dough,need some assistance from you

    Su Su

    (February 17, 2020 - 3:13 pm)

    super clear and helpful! thank you!

    Mark Brown

    (February 17, 2020 - 3:13 pm)

    Good videos, helping me through my uni work. Wondering if you could troubleshoot a little for me, I keep having a problem that some milestones that I copy into the table connect to previous milestones that I have pasted in already. Any advice?

    Carmen González

    (February 17, 2020 - 3:13 pm)

    Thanks for sharing , very useful !

Leave a Reply

Your email address will not be published. Required fields are marked *