Skip to main content
Library homepage
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.  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.

    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?