Friday, March 3, 2023

How to Create a Timeline in Excel

A quick tutorial for making project timelines in Excel

There are several easy ways to create a timeline in Excel. You can use the built-in SmartArt feature to create a timeline graphic in a variety of styles. Or, select a premade timeline template if you’re making a more complex timeline. You can also add a timeline to a pivot table or create your own timeline from scratch. This wikiHow will show you how to create a timeline in Microsoft Excel.

[Edit]Things You Should Know

  • Go to Insert > Illustrations > SmartArt > Process to create a timeline graphic.
  • Or, create a new workbook and search for “timeline” in the template search bar.
  • Add a timeline filter to a pivot table by going to PivotTable Analyze > Insert Timeline.

[Edit]Steps

[Edit]Using SmartArt

  1. Click the tab. This will open the Insert toolbar.[1]
    Create a Timeline in Excel Step 1 Version 5.jpg
    • 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.
  2. Click . It’s in the Illustration tab of the Insert toolbar.
    Create a Timeline in Excel Step 2 Version 5.jpg
    • If you don't see this option click Illustrations in the toolbar first.
  3. Click in the sidebar. This will filter the SmartArt options to display only timeline and process-related graphics.
    Create a Timeline in Excel Step 3 Version 5.jpg
  4. Select the Basic Timeline graphic and click . It’s a right-facing arrow with three circles. This is a good choice for linear timelines and overall milestones. Once you click OK, your timeline graphic will appear on your worksheet.
    Create a Timeline in Excel Step 4 Version 5.jpg
    • 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.
  5. Add text to your graphic. By default, the Basic Timeline graphic starts with three text locations. Click each instance of [Text] and replace it with your own.
    Create a Timeline in Excel Step 5 Version 5.jpg
    • To add top-level bullet points, select a bullet point and press . The timeline graphic will automatically create another circle graphic on the arrow.
    • To create secondary bullet points, select a bullet point and press . This will allow you to add bullet points under the top-level titles.
  6. Click the tab to edit your timeline. There are a variety of options for making your timeline stand out! Here are a few things to try:
    Create a Timeline in Excel Step 6 Version 5.jpg
    • 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.

[Edit]Using a Template

  1. Open Excel and click . This is a button in the left sidebar next to a piece of paper icon. Using a template is easy, since many versions of Excel come with pre-built formats. You can also download user-created templates from the internet.
    Create a Timeline in Excel Step 7 Version 5.jpg
  2. Type “timeline” in the search box and press . The search box is under the “Blank workbook” button. It has the text “Search for online templates” next to a magnifying glass.
    Create a Timeline in Excel Step 8 Version 5.jpg
    • 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.
  3. Click a template to select it. You’ll see a list of templates after searching for “timeline.” Clicking a template will open a window with more information about it.
    Create a Timeline in Excel Step 9 Version 2.jpg
  4. Click . This will open the template as a new Excel file. You’re ready to start editing the template!
    Create a Timeline in Excel Step 10 Version 2.jpg
    • 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.

[Edit]Using a Pivot Table

  1. Open the spreadsheet that has a pivot table. To automatically generate a timeline, your data must be organized into a pivot table. You also need the pivot table analyze menu, which was introduced in Excel 2013.[2]
    Create a Timeline in Excel Step 11 Version 2.jpg
    • 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!
  2. Click anywhere inside the pivot table. This will display the “PivotTable Analyze” tab in the top ribbon.
    Create a Timeline in Excel Step 12 Version 2.jpg
  3. Click . This will open a toolbar with options to manipulate the data in the table.
    Create a Timeline in Excel Step 13 Version 2.jpg
  4. Click . A dialog box will pop up showing fields that correspond to a date format. Note that dates entered as text will not be recognized.
    Create a Timeline in Excel Step 14 Version 2.jpg
  5. Select the applicable field and click . A new box that allows you to navigate through your timeline will appear.
    Create a Timeline in Excel Step 15 Version 2.jpg
  6. Click the down arrow next to the date type. This will open a drop-down menu allowing you to change the filter’s scale to years, quarters, months, or days.
    Create a Timeline in Excel Step 16 Version 2.jpg
  7. Click a time section to filter by that selection. For example, if you set the date type to months and click the NOV section, your pivot table will show only data from November of the selected year.
    Create a Timeline in Excel Step 17 Version 2.jpg
    • You can expand your selection by clicking and dragging the gray handles that appear next to the selection.

[Edit]Using a Basic Spreadsheet (Any Version)

  1. Type the milestones of your timeline in one column. You can name the column header something like “activity” or “deliverable.”
    Create a Timeline in Excel Step 18.jpg
    • 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.
  2. Fill in the start and end dates for each milestone. This can just be an estimate if you don’t have the exact dates yet. After this, you’re done with the basic format! You can edit the font, colors, and borders as needed. You could even add a line graph if you have data you want to include next to the timeline.
    Create a Timeline in Excel Step 19.jpg
    • 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.

[Edit]Video

[Edit]Tips

  • You can also use PowerPoint to make timelines. It has more graphics options, allowing you to customize your graphic with more detail.
  • If you’re looking for more Excel tips, check out how to use VLOOKUP and our IF function tutorial.

[Edit]Related wikiHows

[Edit]References



from How to of the Day https://ift.tt/9MuqfKI

No comments:

Post a Comment