- Take sample data.
2. Select data of Col A and Col C then go to the ribbon, select Insert, and select your chart type from the chart group.
3. Select Chart type as a 2-D column.
4. The Chart looks below.
5. To remove the Vertical Axis, Click on Axis then press the delete option.
6. To Remove Gridline, click on the chart then select the + button, and uncheck the Gridline.
7. To give an Error Bar, click on the chart then select the + button, and check the Error Bar.
8. To change the error Bar, right-click on Error Bar and select Format Error Bar.
9. Change Error bar options.
10. To change the color in the bar, right-click on the chart and select Format Data, in Format Data Series select Fill and choose No fill.
11. To change the Error Bar color, right-click on the chart and select Format Error Bar, in Format Error Bars select Line and choose your color.
12. After that change the border width to 1.5 pt.
13. To change the horizontal Axis border color, right-click on the Axis and select Format Axis, in Axis Option select Line and choose your color.
14. After that change the border width to 1.5 pt.
15. To give Data Labels in the chart click on your chart and select the + button to give your Data labels. Select Data labels and click on the More option.
16. After that go to Label Option and Select Value From Cells.
17. Select the data label range from the sample Data Table.
18. Then uncheck the Value in the Label Option.
19. To give an appropriate chart title, select the title and write your desired title.
20. To change the horizontal Axis borderline type, right-click on the Axis and select Format Axis, in Format axis select End Arrow Type and choose your arrow type.
21. The Chart looks below.
