How to Create Progress Chart In Excel?

  1. Take sample data.

 

 

Progress Chart

 

 

2. Select any cell of data then go to the ribbon, select Insert, and select your chart type from the chart group.

 

 

Progress Chart

 

 

3. Select Chart type as 2-D Bar.

 

 

Progress Chart

 

 

4. The chart looks below.

 

 

Progress Chart

 

 

5. To change the category in reverse on the vertical axis, right-click on the axis and select Format Axis.

 

 

Progress Chart

 

 

6. After that in the Axis Options give a checkmark on the ‘Categories in Reverse Order’ box.

 

 

Progress Chart

 

 

7. To remove the horizontal axis, click on Axis and press Delete.

 

 

Progress Chart

 

 

8. To remove the Chart Title and Legend, click on the Chart Title and Legend then press Delete.

 

 

Progress Chart

 

 

9. To give a horizontal Gridline, click on the chart then select the + button, and check the Gridline. Here we remove the vertical gridline and give a horizontal gridline.

 

 

Progress Chart

 

 

10. To change the gap width and Series Overlap in the bar, right-click on the chart and select Format Data, in Format Data Series select Series Option and change the gap width to 60% and Series Overlap to 100%.

 

 

Progress Chart

 

 

11. To change the color in the first bar, right-click on the chart and select Format Data, in Format Data Series select Fill and choose your color.

 

 

Progress Chart

 

 

12. To change the color in the second bar, right-click on the chart and select Format Data, in Format Data Series select Fill and choose No fill.

 

 

Progress Chart

 

 

13. To change the color in the second bar outline, right-click on the chart and select Format Data, in Format Data Series select Border and choose your color and change Width to 1.5 pt.

 

 

Progress Chart

 

 

14. To bring forward the second bar outline, follow the below steps. Right-click on the bar and select data.

 

 

Progress Chart

 

 

15. Select % of Completion and move up as indicated below image.

 

 

Progress Chart

 

 

16. To give a data label of % completion, right-click on the bar, select Format Data Series, and choose the series type as % Completion.

 

 

Progress Chart

 

 

17. To give Data Labels click on your chart and select the + button to give your Data labels. Select Data labels and click on Inside End or any other option.

 

 

Progress Chart

 

 

18. To give a Chart Title click on your chart and select the + button to give your Chart Title, select Chart Title.

 

 

Progress Chart

 

 

19. To change the chart title name, click the chart title and write the title name. The chart looks below.

 

 

Progress Chart

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories