Creating+Timelines+in+Excel

=Creating Timelines in Excel = =Timelines are useful in a various amount of ways such as making projects, reports, or documenting historical events. Creating a timeline in Excel, however, may become tedious and difficult very quickly. Below is a quicker, easier way to create a timeline in Excel. =  1. Create a column of numbers 1-10 starting at cell B5. 2. Create a column of event labels starting at cell C5. 3. Create a column of heights that will represent leader lines starting at cell E5. 4. In cell F5, enter the formula: =OFFSET($B$4,ROW-ROW($F$4),0,1,1) 5. In cell G5, enter the formula: =OFFSET($C$4,ROW-ROW($G$4),0,1,1) 6. Copy the formulas from F5 & G5 down to F14 & G14.



7. Insert a XY Scatter Chart and set the values as followed: X values=Sheet1!$F$5:$F$14 Y values=Sheet1!$E$5:$E$14 8. Turn off Y-axis, grid lines, legend, and Y values. 9. Click finish. 10. Enter your data.

(Example of timeline)

Jessica Kubala INFO 273