![]() ![]() Instead of creating your own project timeline template in E xcel, download one that's ready made. Set Separated to 100% and Gap Width to 10%.Ĭongratulations! You’ve created a project timeline in Excel. If you want to get rid of the white space between the bars, right click on the top red bar and select Format Data Series. Change the Minimum bound to the number you’ve written down. Hit Cancel.īack in your Gantt chart, right click on the dates above the bars and choose Format Axis. Under General, write down the number listed. To get rid of the white space at the beginning of your Gantt chart, right click on the first Start Date in your data table and choose Format Cells. Then delete the unnecessary bar chart key to create more space. Then click Border Color and select No line, and finally Shadow and unclick the Shadow box. To hide the blue part of each bar, right click on the blue part of any bar and choose Format Data Series. ![]() Select the ‘Categories in reverse order’ checkbox. Right click your list of tasks and select Format Axis. You now have a stacked bar chart indicating the starting dates of your tasks and their durations-but your tasks are in reverse order. Do not select the name of the column (Task), only the task names themselves. Click the spreadsheet icon to the right of Category (X) Axis Labels, then click and drag to highlight the names of your tasks in your table. Right click on any bar in your chart and choose Select Data. Click the spreadsheet icon to the right of the Edit Series form, then select Ok to add durations to your Excel timeline. Select the first duration in your table, and drag your mouse down to the last duration to select all your duration entries. Click the spreadsheet icon next to the Series values field to open the Edit Series window. Select the empty “Series: name” field, then click the first Duration cell in your table. The previous window will appear select ‘Ok.” Step 3: Add Durationsįollow the same process with your Durations column: click Add under Legend Entries (Series). Click on the spreadsheet icon at the end of the Edit Series form. Click on the first Start Date in your table, then drag your mouse down to the last Start Date to highlight all your task start dates. Finally, click on the spreadsheet icon to the right of the “Series values:” field to open the Edit Series window. Click in the empty “Series name:“ field, then click on the Start Date cell of the table you created in step 1. When the Data Source window appears, click Add under Legend Entries (Series). Right click your empty bar chart, then choose Select Data. ![]() Try Wrike for free Step 2: Add Start Dates ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |