How To Create A Bar Chart In Excel

Remove gridlines of above chart.

How to create a bar chart in excel. Select the range a1 b6. Select the data go to insert bar chart cone chart step 2. Locate and open the spreadsheet from which you want to make a bar chart.

When you see the chart this is a normal column chart but it is showing different month revenue of a single zone together. Once you ve formatted your data creating a bar chart is as simple as clicking a couple buttons. In the charts section you ll see a variety of chart symbols.

Be sure to include the column and row headers which will become the labels in the bar chart. Now we need to modify the chart by changing its default settings. Click on ok we will have a clustered bar chart now.

Select the insert tab in the toolbar at the top of the screen. Select the data and insert the clustered column chart. Click on the cone chart and it will insert the basic chart for you.

There are many ways to make bar charts. Select all the data that you want included in the bar chart. First highlight the data you want to put in your chart.

You can draw them by hand. Click the insert tab followed by the bar option beneath the charts heading. Click blank workbook pc or excel workbook mac.

Click on the bar chart button in the charts group and then select a chart from the drop down menu. 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. Select the stacked bar option from the bar menu to transform the data into a bar chart.

To create a bar chart you ll need a minimum of two variables. Excel bar chart step 1. In this example we have selected the first bar chart called clustered bar in the 2 d column section.

In the above example each zone split into a different month so first we need to arrange data based on zone wise. On the insert tab in the charts group click the column symbol. To do so click.

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. Then head to the insert tab of the ribbon. Add labels for the graph s x and y axes.