In the post-apocalyptic world, can you visualize how much time would you have before the Grim Reaper shows on your doorstep? Well, you don’t have to worry about it now. Also, given that Oz du Soleil is here, you do not have to worry about making timelines.
Oz is taking us through an exploratory (and creative) journey of building timelines in Excel 2013. The end result could look as amusing as the image on our right.
Labels on the bars of your timeline may overlap. Adjusting these ‘label heights’ will prevent this overlap from taking place.
Go to Insert > Scatter under Charts. Scatter plots include a wide array of options which we shall exploit to make our data look like a timeline.
Now within Design > Select Data, click on Add. Select the ‘Dates’ as the X values and ‘Label Height’ as Y values.
iii. Edit other data labels as your desire.
What you have now is a dynamic (and cool) timeline. If the table containing your timeline data is connected to some cells or contains some calculations, the timeline will get automatically updated as these cells or calculations change, respectively. Why else would you want to use the power of Excel to make timelines!
Hungry for more? Our very own Oz shows how it’s done and much more in the follow video.
Excel-timeline <————– Click to download the file that Oz used
The next time you have to make a creative-looking timeline and are worried about the data changing, use what you just learned.
Lastly, share this awesome trick with your friends!
Session expired
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.