To add more, right-click on the portion of the timeline where you want to insert a new event and select Add Shape. Unless your list of dates is very short, you’ll quickly run out of spaces on the predesigned timeline. Step 4: Continue adding important dates to the timeline. If you’d rather the text remain a specific size, you can resize the text box instead by clicking on the object and dragging one of the small circles centrally located on the borders of the text box. When typing in the text, the text size will automatically adjust to fit within the confines of the text box. That is, you can go to the Home tab on the Excel ribbon and make changes to font style, shape, and color. Note that you can format the text here just as you would any other text in Excel. Step 3: Click on any of the text placeholders to begin entering your own information. If you don’t like where the object was placed, you can click and drag the timeline to a new location on the worksheet. For this example, we’ll select the Basic Timeline graphic found in the Process grouping.Ĭlick OK and the object will be inserted into the Excel spreadsheet. Step 2: In the Choose a SmartArt Graphic window, locate the diagram that you want to use a basis for your project timeline.
(Click any image in this article for a larger view.) Step 1: Open the Insert tab on Excel’s ribbon and click on SmartArt in the Illustrations category.
#Microsoft office timeline add in how to
Here, we’ll take a look at how to use this feature. There are several ways that you can go about creating a project timeline in Excel 2007 but one of the quickest and easiest methods takes advantage of the new SmartArt graphics tool. This type of project management diagram can be particularly useful if you’re trying to get a general idea of what resources will be needed or if you’re preparing a presentation that’s intended to be a broad overview of the project. A Gantt chart may be a great tool to use when wanting to see a complete timeline of all tasks involved in a project but it can also be very helpful to create a basic project timeline that gives an overview of major events and deadlines associated with that project.
0 kommentar(er)
