Skip to main content
Workforce LibreTexts

16.2: Sparklines

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

    clipboard_e6ab33e572ff354f6b7252024db3fbfd7.png

    Sparklines are very small graphs or charts that exist within a cell. They are usually entered as a quick visual reference or representation of numerical data. There are three types of Sparklines available: Line, Column/Loss. Line & Column Sparklines provide the same type of visual reference of information as charts. Win/Loss Sparklines show an upward-facing chart for positive values and a downward-facing chart for negative values. To add a sparkline to a cell, highlight the cells in which you want to use their data to create a sparkline. Then click on the icon corresponding to the type of Sparkline you would like to create. Once selecting the Sparkline, a Sparkline dialogue box will appear, allowing you to select or change the cells to be used to generate the Sparkline and a cell to select to insert the Sparkline. When all data is entered, click OK and the Sparkline will be inserted in the appropriate cell.

    clipboard_efc4bcee281509de4fd7721f42b612792.png

    clipboard_e982476ad359342c3eaee4217c77cc3e1.png

    Sparkline Design Tools

    After a Sparkline is created, the user can adjust some of the design elements of the Sparkline by selecting the cell and then navigating to the Design Tab in the Excel Ribbon.

    clipboard_e37f2bb3c9243e001b4fe0f0670408847.png

    Using the Design tools, users may edit the Sparkline Data, change the type of Sparkline, and select whether to display different points/stages of data in the sparkline. Users may also adjust the Sparkline color.


    16.2: Sparklines is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer.

    • Was this article helpful?