You can create a fresh timeline, or you can go to the latest drawn one. On the dashboard section, there are four buttons for navigation. You can draw a horizontal or vertical timeline according to your needs. The direction selection on the settings menu allows you to decide the alignment of the timeline. Besides that, you can also set the font size of the dates and events. In the options section, you can define all the parameters of the shapes such as size, color themes, or distance between shapes including the dates. You just need to always put the icon inside the related cell of the icons list. But, of course, it is optional to add.īesides that, you can also change the name of the icons as well as the icons themselves. You can select the icon name from the dropdown button on the icon column. We have prepared a catalog for you to see all available icons. In addition, you can add an icon to each of the events or just some. The template uses the available area for showing those events. Besides that, you can show long-lasting events overlapping each other. The timeline template will show those events using additional lines and separate shapes in the same alignment. You can assign multiple events to the same date. After that, the tool will generate the timeline graph immediately with one button click “ Draw Timeline“. You should input the event name, start and end date respectively. Then, you can adjust the settings of the timeline appearance such as the scale of the boxes, text size, direction ( horizontal or vertical ), etc. It allows you to input the name of events or jobs and set the date or time range. This section is the starting point to create a timeline. In this timeline chart, there are two main sections Data Input and Timeline. Let’s have a look at how easy it is to make your timeline milestone chart in Excel! Excel Timeline Maker Features: In addition, you can show the order of events in time such as a historical timeline. Another reason why people use this template is for future plans. There are other reasons to use this timeline, one of them is organizing your work and keep your tasks in order. This timeline maker is a spreadsheet that allows you to create a timeline that contains both single-day and time-range events. Besides that, it is mostly preferred to show the order of historical events or the events you have gone through within a certain period. Right-click on the x-axis and select "Format Axis.A timeline graph is used for displaying the sequence of events during time periods.To display the year as 15,000 BC or 2,000 AD, you can use a custom number format: You can format individual markers and data labels by first selecting an individual data point or label. When working with the positioning of the events, I find it easiest to set the Min/Max bounds for the horizontal axis to -110 and 110 (or 0 and 110). If you want the vertical axis on the left and all events on the right, set the horizontal axis Minimum value to 0 and edit the Positions in the table to be all positive numbers. At this point, all that is left is to format your chart how you want it and edit the position values for each of the events to get everything to fit nicely.įormat the vertical axis (color, min/max values, number format, etc.) by right-clicking on the axis and selecting Format Axis.