Excel
Menu
How to Create a Bar Chart in Excel
A chart is a nice visual aid when presenting data. One of the more common charts is the bar chart.
Excel Instruction
Bar Chart
- 1.
- Collect the data you want to make the bar chart out of, and make a frequency table.
- 2.
- Highlight the appropriate cell range containing the table, and choose the chart type
Bar chart. - 3.
- Add chart elements and make changes so your chart appears informative and clear. Remember to include a title for your chart!
Example 1
Bar Chart
Let the frequency table below be an overview of the grades within a class. You will now make a bar chart of the data.
- 1.
- Enter the numbers in a spreadsheet.
- 2.
- Mark the whole table, including the titles. Choose
Insertfrom the top menu bar inExcel. The program often recognizes what chart type is fitting for your data, enabling you to choose fromRecommended Charts. - 3.
- When you have chosen the diagram type, the
Chart Editorwill appear. Here you can knock yourself out and style your chart with different colors and effects. Before you do that, it’s a good idea to make sure that you have included chart and axis titles. This is because a chart is supposed to be a good visualization of your data, so you don’t want people looking at your chart to wonder what it’s trying to display, or what kind of information the axes represent.Below is a chart that shows the grade distribution in the class.
