![excel project planner tutorial excel project planner tutorial](https://3.bp.blogspot.com/-CISsTrSBaE0/VuCB04AMJRI/AAAAAAAAEiw/VJ8PVUUzWZ8/s1600/Project-Tracker-Excel.png)
Community Explore user-generated content and stay updated on our latest product features. We already created a fully interactive gantt chart in part 1 of this tutorial. A Step-by-step guide on creating Gantt charts in Excel.On the right, find and select the Basic Timeline, then click 'OK. Insert a stacked bar chart and format it into a Gantt chart.
![excel project planner tutorial excel project planner tutorial](https://i.etsystatic.com/23134868/r/il/26c3fd/2342488441/il_794xN.2342488441_3gtd.jpg)
Select the entire data range that you want to include in your Gantt chart. Go to the Insert tab, click the 'Illustrations' drop-down arrow, and pick 'SmartArt.' When the Choose a SmartArt Graphic window opens, select 'Process' on the left. Open your Excel spreadsheet and locate the data range that includes the tasks, start dates, durations, and deadlines for your project plan. Effective project planning is crucial for the success of any endeavor. Help and Learning A comprehensive knowledge base, including articles, tutorials, videos, and other resources that cover a range of topics related to using Smartsheet. Open Excel to the sheet where you want your timeline. Excel Tutorial: How To Make A Project Planner In Excel.
![excel project planner tutorial excel project planner tutorial](https://i.pinimg.com/originals/0f/d9/8d/0fd98d4992758bf5497f64a5abcfb92c.jpg)
Content Center Articles and guides about project management, collaboration, automation, and other topics to help you make the most of the Smartsheet platform.