Excel Charts - Timeline with Milestones

[@ahmed007Jaber]

Thank you for this Nazya You just inspired me to do something new

[@02loud]

Never made a chart on excel in my life but this was so nice and easy to follow! Thank you!

[@777kiya]

I thought it was going to be long 7 minutes, but everything you said was to the point; and I loved it Thank you

[@NazyaM]

Thank you so much for the appreciation.

[@ravid8331]

That's so simple and crisp.... thank you Nazya !!!

[@NazyaM]

Thank you so much for appreciating. 🙂

[@Julia_USMidwest]

Super demo! Thank you!

[@GoGetSP]

Wish you provided the link to this excel file to download & practice. Thanks!

[@zulfihyder]

Thanks for sharing. Do you know how to simply add more milestones and incorporate those into the timeline

[@Nethrapapa]

You are life saver

[@swirvin7688]

Thank you this actually helped

[@NazyaM]

Most welcome

[@m.raedallulu4166]

That was beautiful genius!

[@NazyaM]

Thank you

[@lucalenzi9922]

Thank you for sharing! I have question: I'd like to generate automatically, and not manually, the values of the "Position" column in order to avoid overlapping. How could it be that formula?

[@NazyaM]

Hi Luca. Did you try the formula RANDBETWEEN? How about - if you make the first value as 1, for example, and in next cell you do it =previous cell+2, and drag it down? That way each of your text will have gaps and it won't overlap. Hope this helps. :-)

[@lucalenzi9922]

@@NazyaM I’ll try it! Thank you 👋

[@hardevsingh761]

How did you manage to highlight both time n height columns before inserting the chart

[@NazyaM]

Hi Hardev. I had converted the data into table (ctrl + t) and used the color format with yellow header. Hope this helps. Please do let me know if you have any more questions.

[@GoGetSP]

@@NazyaM What happens when we convert into table that it reflected both time and height properly?

[@Ankitsingh-fy6sk]

Nice....Can you help me in making a dynamic calendar that can automatically highlight the current date and automatically changes with the month?

[@NazyaM]

Hi there...interesting question. Let me get back to you on that one, with a solution.

[@2000sunsunny]

Cool !! Thank you.

[@NazyaM]

Thank you for appreciating. May God always keep you blessed.

[@DavidHaLevi777]

When I add the chart, I do not get the plus sign to the right of the chart. Can you tell me how to add this or is there a work around from the drop down menus.

[@NazyaM]

Hi Bob. If you don't get the plus sign next to the chart, you should get "Chart Design" ribbon when you click on the chart. In Chart Design ribbon - there is "Chart Layouts" tools on the left, and the very first option "Add Chart Element" is an expandable list of all the options that the plus sign gives you. Hope this helps.

[@DavidHaLevi777]

@@NazyaM Thank you. Very helpful.

[@elizabethblackwell6242]

My timeline keeps adding in random dates in the timeline. There is no milestone or data at all attached to them.

[@hayekfriedman9078]

You;'ll find these simple charts only work for small amounts of data. If you have more than about 8 milestones it doesn't really work.

[@shaimahone]

How to mark date duration as time line chart ?

[@NazyaM]

Hi Shai. I understood your question as - you would like to have dates appear on the timeline chart, is that correct? If yes, then you can mention dates instead of months. Please let me know if this helps. God bless.

[@hehunches]

What if step 1 doesn't work ffs

[@NazyaM]

Hey there...sorry to hear you that. What error are you facing?

[@hehunches]

@@NazyaM for some reason my - and + were not reflected in the chart don't know why but when I choose scatter chart it did who knows excel 2016. Thanks for your response 👍 found another way. Good video you rock

[@NazyaM]

Thanks

[@GoGetSP]

@@hehunches same here, data values are not reflected? What did you do?

[@automata9s915]

This isn’t a race. Slow downnnnnn