Skip to main content
Chemistry LibreTexts

Step 3 - Creating Charts

  • Page ID
    185071
  • \( \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}}\)

    You'll be making three charts to go along with your spreadsheet. Save them as part of your spreadsheet. When you finish the spreadsheet and charts, answer the questions on the handout.

    Create this column chart by selecting the data in columns A, B, and C. Total calories for the meal are included but that is optional. Don't forget to give the chart a title and label the axes.

    chart1_570ed1299358f.png

    chart2_570ed15362070.png

    Create this chart by selecting the fat/non-fat calories for one of the items on your menu. Select the labels in cells C1 and D1 and then the calories. Hold down the Control key to select data that isn't contiguous. Label your data and include the percentage. Don't forget a title!
    Create this chart by selecting your total fat and non-fat calories for the meal found in cells C6 and D6. Select the labels in cells C1 and D1 and then the calories. Hold down the Control key to select data that is not contiguous. Label your data and include the percentage. Don't forget a title!

    chart3_570ed17eb4249.png


    Step 3 - Creating Charts is shared under a CC BY-NC-SA 4.0 license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?