Skip to main content
AmigoFish

The Excel Timeline chart you'll actually keep using (free template included)

From Leila Gharani ยท ยท 10 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Build a dynamic timeline chart in Excel that updates when your dates change. ๐Ÿ“ฅ Download the free timeline template: https://www.xelplus.com/excel-timeline-chart/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-charts&utm_content=timeline#download-section

๐ŸŽ“ 500,000+ enrolled in our courses. Build a whole library of clean business charts in Business Charts in Excel ๐Ÿ‘‰ https://www.xelplus.com/course/business-excel-charts/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=business-charts&utm_content=timeline

No add-ins and no VBA. Put your dates and milestones in an Excel table, add a helper column, and turn a line chart with markers into a timeline with vertical error bars. Data labels show the date and milestone on separate lines. Change a date, add a row or delete one, and the timeline updates.

A short formula staggers the labels above and below the axis so they don't overlap. To always start the pattern on the first row of the table, wherever it sits: =CHOOSE(MOD(ROW()-ROW(TableTime[#Headers])-1,4)+1,10,-10,12,-30)

00:00 A dynamic timeline chart in Excel 00:29 Set up the data as an Excel table 00:46 Add a helper column for chart levels 01:17 Insert a line chart with markers 01:39 Add vertical error bars (Minus, No Cap, 100%) 02:15 Style the error bars and markers 02:53 Why the labels need different heights 03:41 Stagger labels with CHOOSE, MOD and ROW 04:47 Fix the axis start and end dates 05:13 Remove tick marks and axis labels 05:35 Style the axis with arrows 06:10 Add data labels: date and milestone 06:55 Put the date on a new line 07:42 Highlight an important milestone 08:13 Change a date and the timeline follows 08:37 Change the label pattern 08:53 Start the pattern on the table's first row

๐ŸŽฌ McKinsey chart in Excel: https://youtu.be/-Pi68IkutaQ ๐ŸŽฌ Make Excel charts like The Economist: https://youtu.be/wP8NWRR0Fdg

โžก๏ธ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

โœ‰๏ธ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter

๐Ÿšฉ Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani

#excel #excelcharts #exceltips

Back to Leila Gharani ยท Report a problem