Handy hack to create timeline charts
Episode description
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:
Search for them in your podcast platform.