How to display zero percent of progress?

1. How do I show percentage progress in Excel?
2. How do I add a progress bar to a cell in Excel?

How do I show percentage progress in Excel?

Under the Axis label range, select the axis values from the original data; Select Percentage of current completion option if you want to create the progress bar chart based on the percentage values; Then, select the percentage values from the data range.

How do I add a progress bar to a cell in Excel?

Step 2: Add the Progress Bars

Next, highlight the cell range B2:B11 that contains the progress percentages, then click the Conditional Formatting icon on the Home tab, then click Data Bars, then click More Rules: A new window appears that allows you to format the data bars.