However, setting up a project timeline does not have to be difficult. This requires a few steps of styling and adjustment but will get the job done for you. We will use the following data to first tweak of the scatter plot to imitate a lollipop chart. The one we are looking at in this tutorial is the scatter plot, or XY-chart.
How to Make a Timelineīesides the many build-in functions, you probably have used Microsoft Excel for Office 365 to create charts before. Business professional use timelines to present project schedules to their clients as part of reports or presentation decks. Timelines list events in a chronological order on a horizontal timescale. Excel does not offer a native way to create a timeline, but we can tweak a XY-plot to create a professional looking timeline. This step-by-step Excel for Office 365 timeline tutorial explains how to create professional timelines using Microsoft's popular spreadsheet tool.
