This Timeline is great. Can you help me to include hours in the timeline if the whole timeline is only for a couple of days but I would like to share the hours.
Hey, thanks for this awesome video tutorial. I have a question - if the timeline is over a number of years, how can we make the months shorter (e.g. December to Dec) and also show which year it belongs to. Thanks
CHAR(10) is a function that creates a line break when used with a text string within a formula. This allows you to display text on multiples lines within a single cell (or data label).
How does one show this over a series of years including specific dates? That is, say that a timeline begins on 28th November 2021, and ending today with a number of events back looking?
I was able to consult with a friend of mine, but multi-year formulas require the CONCATENATE function and a different formula for the "Data Label" column.
So clear and useful! Thanks!
Lovely. Many Thanks!
This is really beautiful and clean! Thank you very much!
Giving this a try today thank you so much, didnt fancy having to manually enter all this data again into a pdf
amazing bro! thanks from Brazil
Fantastic. Liked the solution. 😅
Glad it helped!
Thank you for the video, it is really helpful and simple to applied!
Thank you - just what the Boss ordered!
EXCELLENT VIDEO!
Brilliant work!!! Very good!!
Hi! Thank you very much for this tutorial. It is amazing! Is it also possible to add an automatic arrow with 'today' in the chart?
Finally!..An accent I can understand, thank you.
Happy to help!
You are awesome! Thank you!!
This Timeline is great. Can you help me to include hours in the timeline if the whole timeline is only for a couple of days but I would like to share the hours.
Thanks for this video. Learnt alot!
I'm glad, thanks!
This video has been incredibly helpful! Thank you for sharing 💯
Very good 👍
4:40 From Excel for Mac version 16.81, the custom Category does not have the Type and Format Code shown on this video. Is it a missing feature on Mac?
Thanks for the video!.
Thanks for watching!
Awesome! thank you!
Thank you for your tutorial. Means a lot
Thanks for watching!
Hey, thanks for this awesome video tutorial. I have a question - if the timeline is over a number of years, how can we make the months shorter (e.g. December to Dec) and also show which year it belongs to. Thanks
Instead of custom format "MMMM" create and use "MMM"
/When I get to the Axis Format page, I don't have the date options. Why is that?
I can't find the Axis Type options in my scatter graph in my Excel 365
Does not work on mac excel.
I can't find the value from cells option in my label options. I'm using Excel on Mac. Anyone please advise
Can someone help with why did he add a (10) in the formula. Amazing video by the way. That part confuse me. Thanks
CHAR(10) is a function that creates a line break when used with a text string within a formula. This allows you to display text on multiples lines within a single cell (or data label).
Why I can not find the date adjustment on format axis 😢
How does one show this over a series of years including specific dates? That is, say that a timeline begins on 28th November 2021, and ending today with a number of events back looking?
I was able to consult with a friend of mine, but multi-year formulas require the CONCATENATE function and a different formula for the "Data Label" column.
There is a Ghantt template in Excel 😊
Where?