2.01 Displaying Data - Creating a Bar Chart


Suppose Mint High School wants to improve its gym.  The student body decides to sell candy to earn money.  The number of cases of candy each class sold as outlined below.

 Freshman 210 Sophomores 310 Juniors 250 Seniors 450

The Principal of the school wants to create a bar chart showing the amount each class sold.  Open an Excel spreadsheet and type in the information from the table above, starting in cells A2 through B5 to create the chart.  Then highlight the information, 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.

2.01 Displaying Data - Creating a Bar Chart is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.