Skip to main content
Workforce LibreTexts

4.2: Information for Spreadsheet Charts

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

    Information for Spreadsheet Charts

    Charts help express data in a table. Before creating a chart, consider the following:

    1. Purpose of the chart – what information do you want to emphasize.

    2. Results to display – which chart is appropriate.

    3. Determine what data to illustrate in the chart – sometimes there is a need to select great quantity of data and other times just a small amount. Different chart types display in distinctive ways.

    4. Understand of elements of a chart – (See 3-D cluster chart elements on page 2 for an explanation of terms for axis, legend, data labels, etc..)

    Types of Charts

    Screen-Shot-2017-07-06-at-10.05.46-AM-300x125.png

    3D Cluster Chart – Chart Elements

    Screen-Shot-2017-07-06-at-10.07.07-AM-300x156.png

    Adjustable Chart Elements

    (Found by clicking on Chart Tools, Design, Chart Layout Group)

    Screen-Shot-2017-07-06-at-10.07.58-AM-300x229.png
    CC licensed content, Original
    • Information For Spreadsheet Charts. Authored by: Fran Wells. License: CC BY: Attribution

    4.2: Information for Spreadsheet Charts is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?