How to make bar charts in excel

If yesterday we told you how to open.xlxs files, today we will see how to make bar charts in Excel. This question is asked by many readers, so we hope that at the end of this article you will no longer have any doubts.

First of all, tell you not to confuse bar charts with column charts. In bar charts, the lines go horizontal and the result can be very practical and productive. Are you ready to start?

How to make bar charts in Excel

From one version of Excel to another it may change a little. We will focus on Excel 2013/2015. In order for the bar graph to work for you, you must have some data inserted in your excel spreadsheet, because the objective of this graph is that it shows you more visually the data you just inserted in Excel.

The normal thing is that you have, for example, a table in which you show data, as an example in a column “manufacturer brands” and in the other “the income they have obtained”. In the following image, you can get an idea.

Once you have your table, clicking on the "Insert" tab > Insert bar graph> Grouped bar , you will have your bar graph done. You will see previews of how the graphic is as you move through the different options (you can even create it in 3D). But to create it completely, you will have to click on the button.

Do you already have your bar graph ? Well now you can customize it as much as you want: colors, width of the bars, order of the labels , etc. So that it looks exactly the way you want. The good thing about Excel is that it allows you many options within this field, so you can work with Excel without limits.

We hope that you no longer have any doubts about how to make bar charts in Excel. If you have doubts, take advantage of the comments!

Are you interested…

• How to download Free Microsoft Office 2013, Office 2016 and Office 365.