Thanks for sharing this. @Engineeringly When I enable category name 3:38, it is displaying dates and not the milestone name. Could you please let me know what needs to be corrected here?
Hi Dhawal, thank you for engaging with our content. The reason we have the name location in here is that to put the milestone name in a proper location where it is clearly visible.
Hi, thank you for engaging with our content. I believe that there won’t be a problem. Apart from the error bars giving a better and easy to understand visual. Still let me try what you said and get back to you with the results.
Question: I'm trying to add a "Today" marker within that timeline, that moves automatically since I use =Today(), but I leave it at the end of my milestones but it shows randomly at the end on the timeline, any fix?
Nice work. There is a bug that if the data was not in the time sequence, for example, the second date is earlier than the first date. Then the label is wrongly assigned.
Hey Duncan, thank you for engaging with our content. Other people have encountered the same issue. Make sure that the dates are in date format. If still not fixed, reach out to me on LinkedIn and let’s solve it there: www.linkedin.com/in/aqhotak
bit out of date now but in case you want to create it in the future the way i got around it was : duplicate the data, to manipulate. =sort() the dates into order then do an =xlookup() function for the milestone name with the dates as your lookuparray. Now it will always sort the dates into time order and then associate the correct label based on the dates in the original table. Only issue with this is the position, if you move something from a name location of 10 for example into the future (or past) something else will take that name location of 10 and your changed data will assume whatever position it replaced.
Hey Hayek, thank you for pointing that out. We were planning to add that in the description of the video to make it easier for the audience. The long explanation at the beginning is because we feel that the audience should clearly understand what they’re going to watch. Thank you once again for the heads up!
Haha, sorry for the inconvenience brother. Anyways you can reach to me directly if there are any questions. Connect with me on LinkedIn at: www.linkedin.com/in/aqhotak
This is the only tutorial I found that actually treats the timeline as a date series and not just a set of equal points. Excellent work!
@@JimLeonard Hey, glad it was of some use to you. Thank you for the positive feedback.
Thank you @Engineeringly for sharing this. Worked well for me. 🙏🙏
Hi Pradeep, thank you for the positive feedback!
This is underrated... awesome work!
Hi Mert, this is really great to hear. We appreciate your positive feedback and will help us further improve the quality of our content. Thank you!
Thanks so much for sharing
Thanks for sharing this. @Engineeringly When I enable category name 3:38, it is displaying dates and not the milestone name. Could you please let me know what needs to be corrected here?
excellent !!!!!!!!!!
Thank you very much for the positive feedback!
Great work! Has helped me a lot
Thank you very much for the positive feedback. We’re glad that our work is having a positive impact!
Very Cool! Thank you mate.
Hi, glad you found it helpful!
Is there a way to give conditional colors for each milestone automatically?
It was very nicely presented, I did not understand the use of NAME LOCATION
Hi Dhawal, thank you for engaging with our content. The reason we have the name location in here is that to put the milestone name in a proper location where it is clearly visible.
Great tutorial! I wonder why do we need to add the "Error bars"? Can not we just use the column chart as at 3:53?
Hi, thank you for engaging with our content. I believe that there won’t be a problem. Apart from the error bars giving a better and easy to understand visual. Still let me try what you said and get back to you with the results.
Question: I'm trying to add a "Today" marker within that timeline, that moves automatically since I use =Today(), but I leave it at the end of my milestones but it shows randomly at the end on the timeline, any fix?
Hey, can you share your spreadsheet with me through LinkedIn (www.linkedin.com/in/aqhotak) so we can give it a look together.
Hi… did you get a response to this? My today marker is doing the same
Hi, awesome work, can you just help me, how to adjust the timeline on the axis with regular intervals of dates?
Hey, thank you for engaging with our content. Can you send me the file you have worked on at www.linkedin.com/in/aqhotak
Hey I just did contact you through the linkedin. Thank you 👏@@Engineeringly
@@LucieSucha-t3y No problem. Got it, fixed it, and sent it back to you!
I have tried changing the dates but milestone position is not moving in the chart, What might be the reason?
Hi Gagan, are you sure that you followed the steps correctly? If yes, send me your file on LinkedIn at www.linkedin.com/in/aqhotak
@@Engineeringly I have the same issue. How to fix this please ?
HI, I am having the same issue. On changing the date nothing happens.
How do reduce size of column to look like a line (name location bar) ?? @enginnerigly
you're so damn genius!
That’s so kind of you. We are doing our best to deliver what we know in the best way possible. Glad that you found it helpful!
How to create name location in numbers. Could you explain.. It will better exposure
Hi Mohammed, do you mean how do we assign the location of the names of the milestones using the numbers on the last column?
@@Engineeringly Hi! Yes, I'd like to know this. How did you assign those?
Nice work. There is a bug that if the data was not in the time sequence, for example, the second date is earlier than the first date. Then the label is wrongly assigned.
Hey Duncan, thank you for engaging with our content. Other people have encountered the same issue. Make sure that the dates are in date format. If still not fixed, reach out to me on LinkedIn and let’s solve it there: www.linkedin.com/in/aqhotak
bit out of date now but in case you want to create it in the future the way i got around it was : duplicate the data, to manipulate. =sort() the dates into order then do an =xlookup() function for the milestone name with the dates as your lookuparray. Now it will always sort the dates into time order and then associate the correct label based on the dates in the original table. Only issue with this is the position, if you move something from a name location of 10 for example into the future (or past) something else will take that name location of 10 and your changed data will assume whatever position it replaced.
Thank you!
Very much appreciated. Glad this has helped.
Instructions start at 5:30.
Hey Hayek, thank you for pointing that out. We were planning to add that in the description of the video to make it easier for the audience. The long explanation at the beginning is because we feel that the audience should clearly understand what they’re going to watch. Thank you once again for the heads up!
@@Engineeringlyit’s not a long video he is just lazy thank you for your effort
Very much appreciated, thank you!
Good work, but if you would wait 3 seconds between clicks, you would have saved me 30 minuts of having to rewind and watch again and again.
Haha, sorry for the inconvenience brother. Anyways you can reach to me directly if there are any questions. Connect with me on LinkedIn at: www.linkedin.com/in/aqhotak
can you just create one for me and i pay you?
@@s2000pill hey, let’s discuss this through email at qaderhotak_3@hotmail.com or LinkedIn www.linkedin.com/in/aqhotak
169 likes, 0 dislikes
Now it’s 172 🤩
@@Engineeringly Good job!