Handy hack to create timeline charts

Excel doesn’t have a built-in timeline chart but we’ll show you how to create one. In this episode you’ll learn how using a scatter chart can help you build a timeline chart.

For easy reference, here are the episode timestamps:

• 0:17 - About timeline charts in Excel
• 1:33 - Hacking the scatter chart to make a timeline chart
• 2:43 - Formatting dates using the range
• 3:32 - Universal formatting shortcut
• 4:27 - Working with the data series and points
• 5:40 - The structure of the data to build the chart
• 7:21 - Linking the title to the cell
• 8:07 - The date format used by Excel and keyboard shortcuts
• 9:29 - Timeline charts overview and recap

Whether you’re tracking historical events or planning future milestones, a timeline chart is a useful tool to create in Excel.

Tune in now to learn this simple technique and start creating your own timeline charts.

Host: Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educator. He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:

• INTHEBLACK
• INTHEBLACK Out Loud
• With Interest
• Excel Tips

Search for them in your podcast platform.