16.2: Sparklines

Last updated
Save as PDF

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}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

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.

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.

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.