Let the frequency table below be an overview of the grades within a class. You will now make a bar chart of the data.
- Enter the numbers in a spreadsheet.
- Mark the whole table, including the titles. Choose
Insert from the top menu bar in
Excel. The program often recognizes what chart type is fitting for your data, enabling you to choose from
- When you have chosen the diagram type, the
Chart Editor will 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.