Войти
  • 15088Просмотров
  • 1 год назадОпубликованоOfficeTimeline

How to make a PROJECT TIMELINE from Excel Data | Office Timeline

This video tutorial provides step-by-step instructions for creating a timeline in Excel using the Scatter Chart feature. Since the process is quite complex and time-consuming, we will also show you a way to instantly build your graphic in PowerPoint by importing existing data from Microsoft Excel. If you'd like to read this tutorial in text form, check it out here: Try Office Timeline for free here: 0:00 What we're going to do 0:36 Formatting Excel Data 1:18 1. Excel Timeline 1:49 Add dates&set positions 2:15 Tweak the chart 2:49 Add connectors 3:38 Add titles 4:10 Beautify the graph 5:15 Result 1 5:26 2. PowerPoint timeline 5:55 Tweak the data table 6:28 Tasks and Milestones 6:44 Generate the visual 7:29 What if data changes? 7:54 Edit with drag&drop 8:19 Add Tasks 8:31 Add swimlanes 8:58 Visual customizations 9:30 Result 2 9:44 Sharing options 10:00 Outro