The bar chart will visualize your Gantt chart’s most important data points Step 3: Input Duration Data The next step is to add another series to your Excel chart to reflect each task’s duration.

By using Excel or Google Sheets to create impactful graphs, you'll be able to captivate your audience, facilitate meaningful discussions, and drive home the key points of your presentation.

How to Make a Chart on Excel With More Than One Variable. One of the more useful features in Microsoft Excel is Insert Charts. You can create a wide variety of charts: bar, line, pie and others.