Skip to main content
Statistics LibreTexts

2.01 Displaying Data - Creating a Bar Chart

  • Page ID
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    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. 

    Freshman 210
    Sophomores 310
    Juniors 250
    Seniors 450

    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.

    Bar Chart Option from the Insert tab on the Main Menu

    The chart that will appear on the Excel spreadsheet is shown below.

    Bar Chart  of Candy Sells by Class

    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.

    Chart Title is 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.

    • Was this article helpful?