How To Create A Bar Chart In Excel

By default the data entered in the first row appears as a blue bar while the data entered in the second row appears as a red bar.

How to create a bar chart in excel. Select the insert tab in the toolbar at the top of the screen. It s in the top left side of the template window. Now we need to modify the chart by changing its default settings.

Click on ok we will have a clustered bar chart now. Add labels for the graph s x and y axes. Then head to the insert tab of the ribbon.

In the charts section you ll see a variety of chart symbols. There are many ways to make bar charts. Click on the bar chart button in the charts group and then select a chart from the drop down menu.

When you see the chart this is a normal column chart but it is showing different month revenue of a single zone together. Excel bar chart step 1. Select the stacked bar option from the bar menu to transform the data into a bar chart.

Click on the cone chart and it will insert the basic chart for you. Click the insert tab followed by the bar option beneath the charts heading. You can draw them by hand.

To do so click. Select all the data that you want included in the bar chart. In the above example each zone split into a different month so first we need to arrange data based on zone wise.

Click blank workbook pc or excel workbook mac. To create a bar chart you ll need a minimum of two variables. In this example we have selected the first bar chart called clustered bar in the 2 d column section.

It resembles a white x on a green background. Once you ve formatted your data creating a bar chart is as simple as clicking a couple buttons. If you want to create a graph from pre existing.

Locate and open the spreadsheet from which you want to make a bar chart. Select the range a1 b6. The independent variable the one that doesn t change such as the name of a brand and the dependent variable the one that changes like sales and percentage.

On the insert tab in the charts group click the column symbol. Remove gridlines of above chart. Select the data and insert the clustered column chart.