- Free Project Timeline Template Excel
- Timeline Template Excel Mac Download Windows 10
- Free Timeline Template For Excel
- Project Timeline Template Excel
- Project Timeline Excel Template Free
- Ms Excel Timeline Template
This step-by-step Pages timeline tutorial explains how to make professional timelines using the popular word processor for Mac.
Although primarily designed for processing text, Pages allows Mac users to also create basic timelines starting from a 2D Bubble Chart. However, the resulting visuals require manual formatting, which can prove time-consuming if you need to build more detailed plans or update them regularly.
To find an Excel timeline template from Microsoft, open Microsoft Excel and type “Timeline” in the search box and click Enter. Note: this template was found using the latest version of Excel on Windows 8. Double-click on the Excel Project Timeline template to open the spreadsheet. Add Your Information to the Timeline in Excel.
Those who need to produce professional-looking visuals faster can try an online timeline maker such as Office Timeline's to simplify their work. Accessible from any browser, the tool enables you to quickly generate, edit and download your graphic as a native PowerPoint slide, which makes it easy to share and include in presentations. This tutorial shows how to create a timeline both manually in Pages and automatically with Office Timeline Online. If you wish learn how to make a Gantt chart in Pages for Mac, please see our Gantt tutorial here.
Which tutorial would you like to see?
How to manually make a timeline in Pages
1. Add a 2D Bubble Chart to your Pages document
Free Project Timeline Template Excel
- Download Timeline Templates. In order to make sure that you find the project timeline template that you need we have made many different templates available for download. You will find templates that allow you to create very simple timelines quickly and you will find templates which allow you to make technical timelines in excel as well.
- The HT column is for the height of the date on the timeline and determines if the date is reflected on the upper portion or lower portion of the timeline. Enter a positive number if you want it on the upper portion and a negative number for the lower portion. Our examples are setup in increments of 5, adjust as necessary.
Timeline Template Excel Mac Download Windows 10
Open Pages and select Blank Landscape from the template gallery to ensure you'll have enough room for your Gantt chart.
Go to Insert → Chart and select 2D Bubble from the menu that pops up. Pages will automatically generate a bubble chart that looks like the one in the image below:
2. Add your project data to the bubble chart
Click on the chart area and then on the Edit Chart Data button that appears.
In the Chart Data table that pops up, add your project data as follows:
i.List your project’s key events (milestones) in the first row, the one populated by default with the month name. Keep the milestone descriptions as short as possible as these will be later displayed on the graphic and you want them to be fully visible.
ii.Use the X column to enter the due dates for each milestone, as shown in the image below.
iii.In the Y column of each milestone, on the same row of the milestone's due date, add a digit such as 1, 2, 3, or 4. These numbers will act as plotting elements that set the milestone bubbles' vertical positioning on the chart. Bubbles that have smaller plotting numbers will be shown closer to the X axis, while those with bigger digits will be placed higher up on the chart.
iv.Lastly, in each milestone's Size column, enter a number like 10, 20, 30 to set the size of the corresponding bubble on the timeline. In my case, I used the value 20 for all my milestones.
After adding all the project data, the resulting chart looks will look this:
Free Timeline Template For Excel
3. Format the graphic to optimize relevance and include key details
As you may have noticed, Pages has automatically added hours to the time series on the timeline’s horizontal axis. If you want to remove the hours for a cleaner look, select the chart area and then go to Axis → Value (X) in the Format pane on the right. Here, choose None from the Time dropdown menu under Value Labels.
Although the legend situated above the graphic gives information about the chart milestones, it may be hard to follow for the viewer. A more efficient way to communicate your milestones' details is to have them displayed directly on their corresponding bubbles. If you want to go with this suggestion, then you need to:
i.Remove the legend: Go to the Chart tab and unselect the box for Legend under Chart Options.
ii.Add bubble labels displaying the milestones’ descriptions and due dates: From the Series tab, tick the boxes for Show Series Name and Values, making sure to select X from the dropdown menu, as shown in the picture below:
Within the same tab, you can change the labels' position using the Location feature, or their date & time format from the Value Data Format section. In my example, I kept the centered placement of the label, but selected None from the Time dropdown menu.
Next, you will need to make the label text more visible by adjusting its size and color. Select all the milestone labels (Shift + Click) and use the Font options within the Bubble Labels tab on the right. I chose to change the font from Regular Helvetica Neue to Bold Helvetica and decrease it from 12 to 10 points.
Seeing that the numerical values from the vertical axis overlap some of the milestone titles and don’t add much to the overall meaning of the chart, I decided to remove them. To do the same, go to Axis → Value (Y) and select None from the dropdown menu under Value Labels.
You may also want to remove the horizontal lines from the graphic as they aren't really relevant to the timeline. To do this, from the Value (Y) tab, go to Major Gridlines and select None from the dropdown menu.
Adding vertical lines to the chart will help you highlight the relative distance between milestones. This is done from the Value (X) tab and requires you to:
i.Choose the type of gridlines you prefer from the dropdown menus under the Major and Minor Gridlines sections. I opted for straight gray lines of 0.5 points for both of them.
ii.Insert more intermediary vertical lines from the Axis Scale section, increasing the number of Minor Steps.
Given that the uppermost milestone of my timeline was not fully included in my gridline area, I corrected that by returning to the Value (Y) tab and setting the Max Scale value under Axis Scale to 5.
Once all the steps above have been carried out, the resulting timeline looks like the one below:
4. Customize your Pages timeline
At this point, your timeline could use a few customizations to look more unique. Here are a few suggestions:
Change the default colors of the chart bubbles - select the milestone you want to recolor, go to the Style tab and use the color indicator next to Fill. Here is how I set the chromatics for my graphic.
Add effects - from the same Style section, you can choose to apply a series of effects such as shadows and strokes. Make sure to select all the chart bubbles (Shift + Click) before making the styling change. Since I didn’t want to burden my graphic too much, I only added a simple black outline using the Stroke feature.
Add a title to your timeline - select the chart area, go to the Chart tab and tick the box for Title under Chart Options. If you want to change the font, size, alignment and color of the title text, double-click on it and use the options from the small pane on the right.
After following the steps above and adjusting sizes a bit more, my final timeline in Pages looks like this:
Download timeline template for Pages
How to make a timeline online automatically
Professionals can illustrate simple plans with timelines built in Pages, but they may encounter limitations in terms of customization and flexibility when dealing with more complex project data.
Creating professional visuals that can be easily updated becomes easier with Office Timeline Online . Allowing you to automatically generate an eye-catching graphic from any browser, the tool also offers a variety of features to help you quickly customize and update your timelines, which can then be downloaded and shared as a .pptx file or .png image. To get started, access the free online timeline maker here and follow the steps below.
1. Add your project's data in Office Timeline Online
Select Timeline from scratch from the New tab in the web app to start building your timeline. You also have the option to choose one of the pre-designed templates provided or to import a schedule from an existing Excel file. In my example, I chose to make a new timeline from scratch.
After selecting Timeline from scratch, you'll be taken to the tool's Data View, where you can enter and edit your project's details.
Enter your milestones and their due dates in the Data View section to generate your timeline in real time, the live preview of which can be seen on the right. Using the Data tab, you can also make a few preliminary styling choices, such as selecting the shape and color for each milestone. Once done, you can access your graphic in full size and personalize it further by clicking either on the preview image to the right or on the Timeline tab on the ribbon.
Project Timeline Template Excel
2. Quickly customize and update your timeline
Project Timeline Excel Template Free
Now that your timeline has been created, you can easily customize and update it as often as necessary. Use the Timeline View to quickly set different colors, shapes, and sizes for your milestones, move them above or below the timeband, or add extras such as Time Elapsed and Today Marker. As you can see in the image below, my final timeline includes milestones and texts of different colors and sizes, which helps me draw attention to key details of my plan.
If you have a free Office Timeline Online account, you can automatically save your timelines in the cloud, access them at any time, and instantly update them when necessary. Add and edit data in the Data tab or adjust due dates directly on the timeline, simply by dragging your milestones left or right. Once ready, your timeline can be downloaded as an editable PowerPoint slide that you can share with colleagues or present in meetings.