2. Show Percentage Progress Bar with Data Bars
- First, select the entire range (C5:C10) containing the progress percentages.
- Then, select Conditional Formatting >> Data Bars from the Home tab.
- Next, choose the fill color for the progress bar from the Gradient Fill or Solid Fill options.
How do I get the percentage progress bar 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.