Key Features
Free App Numbers
To see the version of Numbers on your Mac, choose Numbers About Numbers (from the Numbers menu at the top of your screen). To browse this guide, click Table of Contents near the top of this page, or enter a word or phrase in the search field. You can also download the guide from Apple Books (where available). Number-Crunching: Numbers is a good example of how the best Apple software takes difficult tasks and makes them look easy.As soon as you type '=' into a cell, the Inspector palette on the right. Learn Apple's Numbers iOS app in less than 10 minutes with this complete class! Hope you enjoy:)You can watch the MAC class here: https://youtu.be/FwNuBc2vC. Downloading apps requires an Apple ID. Pages for Mac, Numbers for Mac and Keynote for Mac are available on the Mac App Store. MacOS High Sierra or later required. Numbers '13 is currently available to purchase for £13.99 in the App Store, and comes free of charge with every Mac purchased after 1st October 2013. Create a New Spreadsheet Let's kickstart this tutorial by launching Numbers and creating a new spreadsheet.
Office 2016 mac 3 users. Latest Version: 6.2.1
Rated 2.5/5 By 3,915 People
What does Numbers do? Create gorgeous spreadsheets with Numbers for Mac. Get started with one of many Apple-designed templates for your home budget, checklist, invoice, mortgage calculator, and more. Add tables, charts, text, and images anywhere on the free-form canvas. As soon as you start typing a formula, you'll get instant suggestions and built-in help for the over 250 powerful functions. Animate your data with new interactive column, bar, scatter, and bubble charts. Easily filter through large tables. Automatically format cells based on numbers, text, dates, and durations with new conditional highlighting. And with an all-new calculation engine, Numbers is faster than ever before.With iCloud built in, your spreadsheets are kept up to date across all your devices. And with real-time collaboration, your team will be able to work together at the same time on a Mac, iPad, iPhone, or iPod touch — even on a PC using iWork for iCloud.Collaborate with others at the same time• With real-time collaboration, your whole team can work together on a spreadsheet at the same time• Collaboration is built right in to Numbers on the Mac, iPad, iPhone and iPod touch• PC users can collaborate too, using Numbers for iCloud• Share your document publicly or with specific people• You can easily see who's currently in the document with you• View other people's cursors to follow their edits• Available on spreadsheets stored in iCloud or in BoxGet started quickly• Over 30 Apple-designed templates give your spreadsheets a beautiful start• Simplified toolbar gives you quick access to shapes, media, tables, charts, and sharing options• The new Format Panel automatically updates based on selection• Use Smart Categories to see your data in a whole new way• Quickly organize and summarize tables to gain new insights• Import and edit Microsoft Excel spreadsheets• Import and edit Comma Separated Values (CSV) and tab-delimited text• Quickly open password-protected spreadsheets using Touch ID on supported MacsBeautiful spreadsheets• Place tables, charts, text, and images anywhere on the free-form canvas• Add and resize multiple tables on a single sheet• Create great-looking tables with enhanced cell border styling tools• Use gorgeous preset styles to make your text, tables, shapes, and images look beautiful• Use donut charts to visualize data in an engaging new way• Add an interactive image gallery to view a collection of photos• Insert photos, music, and video with the Media Browser• Enhance your spreadsheets with a library of over 700 editable shapesFormulas for everyone• Choose from over 250 powerful functions• Get function suggestions as soon as you start typing a formula• Search the integrated function browser for built-in help and sample formulas• Get live formula results, error checking, exact value, and cell format with the new smart cell view• Easily add stock information to spreadsheets• Add your favorite functions to Quick Calculations for instant resultsEverything adds up. Beautifully• Insert gorgeous 2D and 3D charts• Animate data with new interactive column, bar, scatter, and bubble charts• Automatically highlight cells based on rules for numbers, text, dates, and durations• Easily filter through large tables• Change values in cells using sliders, steppers, checkboxes, pop-ups, and star ratingsiCloud• Turn on iCloud so you can access and edit your spreadsheets from your Mac, iPad, iPhone, iPod touch, and iCloud.com• Access and edit your spreadsheets from a Mac or PC browser at www.icloud.com with Numbers for iCloudShare your work• Export your spreadsheet to CSV, PDF, and Microsoft Excel• Use 'Open in Another App' to copy spreadsheets to apps such as DropboxSome features may require Internet access; additional fees and terms may apply.
Download for MacOS - server 1 --> Free
This step-by-step Numbers timeline tutorial shows how to make professional timelines inside the popular spreadsheet app for Mac.
Mac users who want to create visual plans or chronologies in Apple's Numbers can do so using the tool's 2D Bubble Chart feature and some manual formatting to create a basic timeline. However, the resulting graphic may lack the flexibility and precision required for professional presentations such as project reports and client reviews.
Those who need to add more details to their timeline or to regularly update it for important meetings can build comprehensive yet clear visuals using an online timeline maker called Office Timeline. Enabling you to quickly generate your graphic from your browser, the tool also lets you download it as a native PowerPoint slide, which can be easily edited, shared and included in presentations. Below, I will demonstrate how to make a timeline both manually in Numbers and automatically with Office Timeline Online. To learn how to make a Gantt chart in Numbers for Mac, please see our Gantt tutorial here.
Which tutorial would you like to see?
How to make a timeline in Numbers
1. Enter your project's milestones and dates into a table.
Create a new Numbers sheet by selecting the Blank type in the Basic section of the template gallery.
List the key milestones of your project in the first row of the default table displayed in the newly created sheet, as shown in the image below.
Use the row below to add the due dates for each of the milestones.
To start building your timeline in Numbers, you will also need to allot plotting numbers to every milestone in the table to define their vertical placement on the graphic. Therefore, use the third row of the table to enter a sequence of numbers such as 1, 2, 3, and 4 as in the example below.
2. Create a basic timeline using the Bubble Chart feature
Select all the data in your table, click on the Insert tab on the Numbers ribbon and go to Chart.
Choose 2D Bubble chart from the menu that pops up.
A simple bubble chart like the one below will be automatically generated on your Numbers sheet:
3. Format your graphic to optimize legibility and add key data
Depending on the number of milestones you've entered, the auto-generated bubble chart might look a bit crammed, so you may want to resize it to ensure a better fit. To do this, simply select the chart area and drag its sizing handles to reach the desired height and width.
Since only your milestone dates and plotting numbers are the ones taken as reference for the two axes of your chart, there is not much information shown on your timeline right now. To provide the audience with more details, you can manually add milestone descriptions to each bubble on the graphic using the Text feature of the app. To do so:
i.Click on the small 'T' icon on the Numbers top taskbar:
ii.Drag and drop the newly inserted text box below or near one of the milestone bubbles.
iii.Double-click on the text box to type in your milestone title and use the Style pane that appears on the right to change the text font, size, style and alignment. In my case, I used black, bold Helvetica Neue for the milestone titles.
I also wanted to remove all the horizontal lines that cut across my timeline as I didn't feel they added any value to the graphic. If you want to make this change:
i.Select the chart area and go to the Axis tab of the Format pane on the right.
ii.Select Value (Y) in order to apply the change to the horizontal axis.
iii.In the Axis Scale section, under Steps, use the up-down controls next to Major to decrease the number to 1.
While in the Axis section, you may want to add vertical lines to better highlight the relative distance between your milestones. To do this, click on the Value (X) tab and:
i.Go to Major Gridlines and set the style, color and width of your vertical lines. In my example, I used a straight, grey line with a width of 1 point.
ii.Repeat the action for Minor Gridlines. I kept the same choices as above for these as well.
iii.Go to the Axis Scale section above and use the up-down controls to increase the value for Minor Steps. In my example, I increased it to 3.
After completing all the steps above, your graphic should look like this:
4. Customize your timeline's milestones
Now that you've formatted your timeline properly, you can apply a few styling choices to the milestones (chart bubbles) to make them stand out more.
To recolor all your milestones simultaneously, select any of the bubbles and go to the Style tab of the Format pane. Here, click on Fill to choose a new color. In my example below, I went for a dark navy blue.
If you want to color the chart bubbles individually, you'll need to break down your milestones into separate series or categories. To do so, go to your project data table and:
i.Rename the Position row into Color 1 and then add a new line below, which will be called Size. Enter the same number in the Size cell of each milestone to keep all bubbles the same size. In my example below, I used '20' for all.
ii.Right beneath, insert a set of two rows for each new color category you wish to create. You can name them Color 2 & Size, Color 3 & Size etc., just like in the image below.
iii.Once finished, to move a milestone into a new category, cut its Color 1 (former Position) and Size values and paste them into whichever of the newly added pairs of rows. Don't worry if this seems to mess up your graphic – we'll fix it right away, in step 'iv.'
iv.To update the graphic with the different color categories created, select the chart area, click on Edit Data References, and then drag the table select handle to include the new rows as well. Numbers will automatically generate multiple-colored bubbles for your milestones.
Note: Looking at my table, you'll notice that I've kept some of my milestones' Color & Size values on the same rows. This means they'll all belong to the same series, and any styling changes made will apply to all of them at once, while the rest of the bubbles can be customized individually.
v.To change the default colors generated by Numbers for your new milestone categories, select the bubble (or bubbles) you want to customize and use the Fill options from the Style tab. Here is how I set up the colors for my graphic:
From the same Style section, you can also apply various effects to your chart bubbles, like adding shadows or strokes. However, it is recommended that you keep these to a minimum to not burden your visual too much. In my example, I selected all the bubbles with Shift + Click and added a simple outline to them using the Stroke feature.
If you want to have the exact milestone dates displayed on your graphic, select the chart area, go to the Series tab of the Format pane, and, in the Bubble Labels section, check the box in front of Values. You will then need to choose X from the dropdown menu on the right, so that the dates appear inside the chart bubbles. To change the label placement in relation to the bubbles, use the Location feature beneath Value Data Format.
5. Customize your chart area
To personalize your timeline further, you can also make some changes to the chart area using the customization options available in the Format pane's Chart and Axis tabs of the Format pane. For instance, you can:
Add a title to your graphic: From the Chart tab, check the box for Title under Chart Options. In my example, I also removed the Legend of my timeline, by unticking its corresponding box.
Customize fonts: While still in the same tab, you can change the font type, style and size for the entire chart using the options under Chart Fonts. I chose to change the style from Regular to Medium to make the text more easily readable.
Note: You can further customize the title or text along the X axis separately by double-clicking on the desired element and then making changes from the pane that appears on the right.
Remove unnecessary labels. In my example, I also wanted to remove the axis labels ('0' and '4') on the left of the graphic because I felt they could create confusion. If you want to do the same, go to the Axis tab in the Format pane, click on Value (Y), and select 'None' from the Value Labels dropdown.
After carrying out all the steps above and trying out several font sizes, my final timeline in Numbers looks like this:
Download timeline template for Numbers
How to make a timeline online automatically
Numbers allows Mac users to build a basic timeline, but some may feel they need a bit more flexibility and customization options to create professional visuals and update them easily for recurring communications.
Professionals who want to make eye-catching timelines more quickly can do so using Office Timeline Online . The browser-based tool helps you automatically generate an appealing graphic that you can customize and update with a few clicks. It also lets you download it as a .pptx file or .png image so you can quickly share it with others. To get started, access the free app here and follow the steps below. To be able to include more than 10 items on your graphic, you will need
This step-by-step Numbers timeline tutorial shows how to make professional timelines inside the popular spreadsheet app for Mac.
Mac users who want to create visual plans or chronologies in Apple's Numbers can do so using the tool's 2D Bubble Chart feature and some manual formatting to create a basic timeline. However, the resulting graphic may lack the flexibility and precision required for professional presentations such as project reports and client reviews.
Those who need to add more details to their timeline or to regularly update it for important meetings can build comprehensive yet clear visuals using an online timeline maker called Office Timeline. Enabling you to quickly generate your graphic from your browser, the tool also lets you download it as a native PowerPoint slide, which can be easily edited, shared and included in presentations. Below, I will demonstrate how to make a timeline both manually in Numbers and automatically with Office Timeline Online. To learn how to make a Gantt chart in Numbers for Mac, please see our Gantt tutorial here.
Which tutorial would you like to see?
How to make a timeline in Numbers
1. Enter your project's milestones and dates into a table.
Create a new Numbers sheet by selecting the Blank type in the Basic section of the template gallery.
List the key milestones of your project in the first row of the default table displayed in the newly created sheet, as shown in the image below.
Use the row below to add the due dates for each of the milestones.
To start building your timeline in Numbers, you will also need to allot plotting numbers to every milestone in the table to define their vertical placement on the graphic. Therefore, use the third row of the table to enter a sequence of numbers such as 1, 2, 3, and 4 as in the example below.
2. Create a basic timeline using the Bubble Chart feature
Select all the data in your table, click on the Insert tab on the Numbers ribbon and go to Chart.
Choose 2D Bubble chart from the menu that pops up.
A simple bubble chart like the one below will be automatically generated on your Numbers sheet:
3. Format your graphic to optimize legibility and add key data
Depending on the number of milestones you've entered, the auto-generated bubble chart might look a bit crammed, so you may want to resize it to ensure a better fit. To do this, simply select the chart area and drag its sizing handles to reach the desired height and width.
Since only your milestone dates and plotting numbers are the ones taken as reference for the two axes of your chart, there is not much information shown on your timeline right now. To provide the audience with more details, you can manually add milestone descriptions to each bubble on the graphic using the Text feature of the app. To do so:
i.Click on the small 'T' icon on the Numbers top taskbar:
ii.Drag and drop the newly inserted text box below or near one of the milestone bubbles.
iii.Double-click on the text box to type in your milestone title and use the Style pane that appears on the right to change the text font, size, style and alignment. In my case, I used black, bold Helvetica Neue for the milestone titles.
I also wanted to remove all the horizontal lines that cut across my timeline as I didn't feel they added any value to the graphic. If you want to make this change:
i.Select the chart area and go to the Axis tab of the Format pane on the right.
ii.Select Value (Y) in order to apply the change to the horizontal axis.
iii.In the Axis Scale section, under Steps, use the up-down controls next to Major to decrease the number to 1.
While in the Axis section, you may want to add vertical lines to better highlight the relative distance between your milestones. To do this, click on the Value (X) tab and:
i.Go to Major Gridlines and set the style, color and width of your vertical lines. In my example, I used a straight, grey line with a width of 1 point.
ii.Repeat the action for Minor Gridlines. I kept the same choices as above for these as well.
iii.Go to the Axis Scale section above and use the up-down controls to increase the value for Minor Steps. In my example, I increased it to 3.
After completing all the steps above, your graphic should look like this:
4. Customize your timeline's milestones
Now that you've formatted your timeline properly, you can apply a few styling choices to the milestones (chart bubbles) to make them stand out more.
To recolor all your milestones simultaneously, select any of the bubbles and go to the Style tab of the Format pane. Here, click on Fill to choose a new color. In my example below, I went for a dark navy blue.
If you want to color the chart bubbles individually, you'll need to break down your milestones into separate series or categories. To do so, go to your project data table and:
i.Rename the Position row into Color 1 and then add a new line below, which will be called Size. Enter the same number in the Size cell of each milestone to keep all bubbles the same size. In my example below, I used '20' for all.
ii.Right beneath, insert a set of two rows for each new color category you wish to create. You can name them Color 2 & Size, Color 3 & Size etc., just like in the image below.
iii.Once finished, to move a milestone into a new category, cut its Color 1 (former Position) and Size values and paste them into whichever of the newly added pairs of rows. Don't worry if this seems to mess up your graphic – we'll fix it right away, in step 'iv.'
iv.To update the graphic with the different color categories created, select the chart area, click on Edit Data References, and then drag the table select handle to include the new rows as well. Numbers will automatically generate multiple-colored bubbles for your milestones.
Note: Looking at my table, you'll notice that I've kept some of my milestones' Color & Size values on the same rows. This means they'll all belong to the same series, and any styling changes made will apply to all of them at once, while the rest of the bubbles can be customized individually.
v.To change the default colors generated by Numbers for your new milestone categories, select the bubble (or bubbles) you want to customize and use the Fill options from the Style tab. Here is how I set up the colors for my graphic:
From the same Style section, you can also apply various effects to your chart bubbles, like adding shadows or strokes. However, it is recommended that you keep these to a minimum to not burden your visual too much. In my example, I selected all the bubbles with Shift + Click and added a simple outline to them using the Stroke feature.
If you want to have the exact milestone dates displayed on your graphic, select the chart area, go to the Series tab of the Format pane, and, in the Bubble Labels section, check the box in front of Values. You will then need to choose X from the dropdown menu on the right, so that the dates appear inside the chart bubbles. To change the label placement in relation to the bubbles, use the Location feature beneath Value Data Format.
5. Customize your chart area
To personalize your timeline further, you can also make some changes to the chart area using the customization options available in the Format pane's Chart and Axis tabs of the Format pane. For instance, you can:
Add a title to your graphic: From the Chart tab, check the box for Title under Chart Options. In my example, I also removed the Legend of my timeline, by unticking its corresponding box.
Customize fonts: While still in the same tab, you can change the font type, style and size for the entire chart using the options under Chart Fonts. I chose to change the style from Regular to Medium to make the text more easily readable.
Note: You can further customize the title or text along the X axis separately by double-clicking on the desired element and then making changes from the pane that appears on the right.
Remove unnecessary labels. In my example, I also wanted to remove the axis labels ('0' and '4') on the left of the graphic because I felt they could create confusion. If you want to do the same, go to the Axis tab in the Format pane, click on Value (Y), and select 'None' from the Value Labels dropdown.
After carrying out all the steps above and trying out several font sizes, my final timeline in Numbers looks like this:
Download timeline template for Numbers
How to make a timeline online automatically
Numbers allows Mac users to build a basic timeline, but some may feel they need a bit more flexibility and customization options to create professional visuals and update them easily for recurring communications.
Professionals who want to make eye-catching timelines more quickly can do so using Office Timeline Online . The browser-based tool helps you automatically generate an appealing graphic that you can customize and update with a few clicks. It also lets you download it as a .pptx file or .png image so you can quickly share it with others. To get started, access the free app here and follow the steps below. To be able to include more than 10 items on your graphic, you will need
1. Enter your project data in Office Timeline Online
From the New tab in Office Timeline Online, select Timeline from scratch or choose one of the pre-designed templates provided to start building your timeline. You also have the option 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 directed to the web tool's Data View, which lets you enter and edit your project's details.
In the Data View section, list your milestones along with their due dates. Your timeline will be generated in real time as you add your data, and a live preview of it will be shown on the right. The Data tab also lets you make a few preliminary styling choices, such as setting the shape and color for each milestone. Once you finish, select the Timeline tab on the ribbon or click the preview image to the right of your data list to go the Timeline View, where you can see your graphic in full size and personalize it further.
2. Customize and update your timeline with ease
Numbers App Download For Windows
With Office Timeline Online, your newly created visual can be easily customized and updated as often as necessary. From the Timeline View, you can change colors, shapes, sizes and fonts at the click of a button, add details such as Time Elapsed and Today Marker, or move milestones above or below the timeband. In my final timeline below, you can see that I've also added a few more milestones and played with colors, sizes and fonts to draw attention to specific items.
With a free Office Timeline account, your graphic will be automatically saved in the cloud, so you can access it at any time and update it on the fly whenever necessary. You can add or edit data effortlessly from the Data tab, or drag & drop milestones to update their dates instantly directly from your graphic. When finished, your timeline can be downloaded as an editable PowerPoint so you can easily present it or share it with others.
Free Numbers Templates For Mac
See how easy it is to make timelines with Office Timeline Online
