Suppose Mint High School wants to improve its gym. The student body decides to sell candy to earn money. Listed below are the number of cases each class sold.
The school's principal wants to create a bar chart showing the amount each class sold. To create the chart, open an Excel spreadsheet and type in the information from the table above, starting in cells A2:B5.
- In cell A2 enter Freshman.
- In cell B2 enter 210.
- In cell A3 enter Sophomores.
- In cell B3 enter 310.
- In cell A4 enter Juniors.
- In cell B4 enter 250.
- In cell A5 enter Seniors.
- In cell B5 enter 450.
Then highlight the information, and click on the Insert option on the main menu. In the Charts section of the Menu bar, select the Column Charts. The first option in the list of charts is fine.
The chart that will appear on the Excel spreadsheet is shown below.
We need to add a title to the chart. To do this, click on Chart Title, and a box will appear.
Highlight the word Chart Title and enter Candy Sales by Class.