How to draw bar graphs in Excel spreadsheets

How to draw bar graphs in Excel spreadsheets


How to create a bar chart in Excel helps you create files in Excel more professional, more intuitive, easier to express your wishes to viewers. To create a bar chart in Excel, follow the instructions below.


In Excel there are many useful features, especially the support for charts to show data more visually. If you already know how Create pie chart in excelToday, Taimienphi.vn will guide you how to draw bar graphs in Excel.

How to create a bar chart in Excel

How to draw a bar chart in an Excel spreadsheet

1. Draw bar charts in Excel 2016 and 2013 spreadsheets

Step 1: For example, if we have the following table and need to draw bar graphs in Excel spreadsheets, the first task is on the section Insert then select Charts, here we will proceed to select the chart.

expression in Excel

Step 2: Here you have the right to choose many types of columns and to draw bar graphs in the Excel spreadsheet we choose 2D column for popularity.

expression in Excel

And you will get the result as shown below.

expression in Excel

Step 3: If you want to change the chart type, you can right-click on the chart and select Change Chart Type.

expression in Excel

Step 4: Then choose a different style depending on your preference.

expression in Excel

Also we have part design where you can change the style of the chart into a more eye-catching form.

expression in Excel

Good Quick Layout Allows you to change the display style of fields in Excel.

expression in Excel

Or Change Colors to change color by block to make it easier to distinguish when graphing an Excel column.

expression in Excel

And after a few editing steps, you will have the results of drawing bar graphs in Excel 2016 and 2013 spreadsheets as below.

expression in Excel

2. Draw bar graphs in Excel 2010 and 2007 spreadsheets

In this article, Taimienphi.vn will guide you on Excel 2010, download Office 2010 to install on your computer. In addition, the installation of office 2007 is being used by many people also bring you many interesting and effective features.

Step 1: Open the Excel File containing the data you want to chart, then select all the data in the table. Here, Taimienphi.vn performed on Excel 2010 with a table of statistics saving the number of users of online payment services.

expression in Excel

Step 2: Next, look at the horizontal menu and go to Inser -> Column. Here, choose the type you want

About expression by excel

Step 3: After clicking the chart type immediately, Excel will display the bar graph data according to the type you selected. You can see the chart on the right as below

About expression by excel

Step 4: Users can also change the type Style whatever you like, you can come in Thiết kế and Format to format and change.

About expression by excel

About expression by excel

To set other options for chart like add Title, add comments … you can go to Format chart as shown below and then tick the items Label contains

have been dropped by excel file

And results

About expression by excel

3. Draw a bar chart in an Excel 2003 spreadsheet

Step 1: Similar to the steps above, to draw bar graphs in Excel 2003 spreadsheets see instructions with the data below.

expression in Excel

Step 2: Then blacken the data to be selected and then selected Insert >Chart.

expression in Excel

Step 3: Select the bar chart you want as you like.

expression in Excel

Then choose a chart type to draw a bar graph in Excel spreadsheet more visually.

expression in Excel

Step 4: Next you tweak for a more informative chart.

expression in Excel

Create labels for the chart you are creating.

expression in Excel

Add values ​​to the chart, but keep in mind that adding too many graphs can be very confusing.

expression in Excel

Selection As object in to create a chart directly on the current sheet or select as new sheet If you want to create a separate chart.

expression in Excel

The result after the above operations will be like the chart below.

expression in Excel

To edit, just right click on the chart then select Chart Type.

expression in Excel

Here you can change arbitrary charts like the versions above.

expression in Excel

In section Chart Options You will be changing more features.

expression in Excel

https://thuthuat.taimienphi.vn/ve-bieu-do-hinh-cot-trong-excel-2615n.aspx
Above, Taimienphi has just guided you to manipulate to draw bar graphs in Excel. Drawing charts in Excel helps readers and viewers to receive information more understandably, easier to compare and capture, turning dry data into vivid, aesthetic charts. This is also a basic trick in creating a chart that users need to be familiar with before coming to the more difficult chart creation.

.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *