This guide shows how to create progress bars in Excel using Bar Charts and Conditional Formatting on a Windows 11/10 PC. Take ...

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.

(Don’t worry; we’ll fix that in a minute.) Step 5: Transform Into a Gantt Chart To turn your Excel stacked bar chart into a visual Gantt chart, you need a few tweaks.

Chart the Summary Data Click "Insert" in Excel's ribbon. Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart.

This is especially useful if you've added multiple rows to extend the length of the workflow, because as you add shapes, Excel compensates by making everything smaller to fit the original border size.