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.
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.
And you will get the result as shown below.
Step 3: If you want to change the chart type, you can right-click on the chart and select Change Chart Type.
Step 4: Then choose a different style depending on your preference.
Also we have part design where you can change the style of the chart into a more eye-catching form.
Good Quick Layout Allows you to change the display style of fields in Excel.
Or Change Colors to change color by block to make it easier to distinguish when graphing an Excel column.
And after a few editing steps, you will have the results of drawing bar graphs in Excel 2016 and 2013 spreadsheets as below.
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.
Step 2: Next, look at the horizontal menu and go to Inser -> Column. Here, choose the type you want
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
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.
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
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.
Step 2: Then blacken the data to be selected and then selected Insert >Chart.
Step 3: Select the bar chart you want as you like.
Then choose a chart type to draw a bar graph in Excel spreadsheet more visually.
Step 4: Next you tweak for a more informative chart.
Create labels for the chart you are creating.
Add values to the chart, but keep in mind that adding too many graphs can be very confusing.
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.
The result after the above operations will be like the chart below.
To edit, just right click on the chart then select Chart Type.
Here you can change arbitrary charts like the versions above.
In section Chart Options You will be changing more features.
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.