SmartArt is a built-in Excel feature that makes a graphic layout that you can add data to. It does not transform your existing data.
If you don’t see this option click Illustrations in the toolbar first.
If you’re having trouble finding this option, click each of the graphics to see their names. You can adapt other Process graphics to use as a timeline. To see the name and description of each graphic, click its icon in the selection menu.
If you’re having trouble finding this option, click each of the graphics to see their names. You can adapt other Process graphics to use as a timeline. To see the name and description of each graphic, click its icon in the selection menu.
To add top-level bullet points, select a bullet point and press ↵ Enter. The timeline graphic will automatically create another circle graphic on the arrow. To create secondary bullet points, select a bullet point and press Tab ↹. This will allow you to add bullet points under the top-level titles.
To add top-level bullet points, select a bullet point and press ↵ Enter. The timeline graphic will automatically create another circle graphic on the arrow. To create secondary bullet points, select a bullet point and press Tab ↹. This will allow you to add bullet points under the top-level titles.
Change the layout. Click different layouts in the “Layouts” section. This will keep the text you’ve already entered, so you can easily see different options. Change the style. Click various styles to find the one that works best for your presentation. Change the colors. Click Change Colors to see a drop down menu with different color palettes.
If you prefer working in PowerPoint, you can create a roadmap with milestones in that app instead.
In older versions of Excel, you’ll see a section called “Available Templates” instead of the “Search for online templates” search box. Some versions of Excel will show a New from Template button. If your timeline tracks the progress of a branching project with many tasks, consider looking for “Gantt chart” templates instead.
Click objects to select them. You can move the object by clicking and dragging it. Click the Format tab to edit the shape’s color, outline, and text style. Double-click text in the template to change the text. Some templates will have help text when you click objects, providing more information about that section.
This method is great for filtering data by time and making a dynamic timeline. Pivot tables are a useful way to quickly see your information in new ways. There are plenty of interesting tricks in Excel!
You can expand your selection by clicking and dragging the gray handles that appear next to the selection.
This method uses the cells of the spreadsheet to create and format your own timeline. This is a good method if you’re just sharing this information with your team, rather than presenting it.
Create a start and end column next to the milestone titles column. Type in the start and end dates for each milestone on your timeline. You can also create a notes column to include information about each milestone.
