In this article we will see how to create a simple a Column Chart and a Bar chart

Column Chart

In the data range from A1 to B11 of a worksheet, I have the price details of 10 food items. For creating a column chart from the data given below.

Select the source data for the chart i.e the range of cells from A1:B11

Click on Insert Tab

Click on the Icon for Column/Bar chart present in the Group for charts

Select Clustered Column from the available options

2 Shortcuts to create a Column Chart

  • Select the data and press ALT + F1 to insert a chart into the same sheet
  • Select the data and press F11 to create the chart as a separate sheet

Bar Chart

In the data range from A1 to B6, I have the  5 year sales data of a particular company. For creating a Bar chart from the data given below,

Select the source data for the Bar chart i.e the range of cells from A1:B6

Click on Insert Tab

Click on the Icon for Column/Bar chart present in the Group for charts

Select Clustered Bar from the available options

Bar Chart in Excel

For changing the Chart Style

Select the Chart > Click on Design Tab > choose a style from the available chart styles