How to Create a Vertical Timeline in Excel

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=1R8Ll3Ltyok

Learn how to create a vertical timeline in Excel from scratch using a Scatter chart, data labels, and error bars for leader lines. The technique applies to horizontal timelines as well. Download the template: https://www.vertex42.com/ExcelTemplat... • 0:00 Set up the Table of Events • 0:47 Insert the Scatter Chart (creates a horizontal timeline by default) • 1:01 Make the timeline vertical by switching the X and Y axes • 1:18 Cleanup - remove gridlines, set the x-axis min/max range • 1:38 Add leader lines via Error Bars • 2:17 Style the timeline markers • 2:33 Add the event labels (via data labels) • 3:04 Style the vertical axis and set the Min/Max range • 3:30 Style the chart and move markers and individual labels • 4:16 Edit the chart title • 👍 Remember to Subscribe! • FOLLOW VERTEX42 HERE: • Instagram: / vertex42 • Facebook: / vertex42 • Pinterest: / vertex42 • Twitter: / vertex42 • LOOKING FOR MORE SPREADSHEETS? START HERE: • https://www.vertex42.com/ExcelTemplates/

#############################

New on site