Plots data as miniature charts within a worksheet cell.

Available in line, column or win/loss formats.

Position Sparklines near data for maximum impact.

Data Format

• x-axis: Categories (e.g. time)
  • Categories are plotted (but not displayed) on the horizontal axis.
• y-axis: Series (e.g. total population)
  • A Sparkline requires a row of data and a cell location.
  • Series are plotted on the vertical axis.
    • Sparklines can be plotted on their own or similar axes.
    • Maximum vertical values can be per Sparkline or similar for all.
  • Data can be plotted left-to-right or right-to-left.
  • Sparklines handle positive and negative values.
  • First, Last, High and Low Points can also be highlighted with markers.

Try it now!

• Select a region using the dropdown list to view the varied population data points and sets.
• Note how the table and title adjust to reflect the different population values of each country/region.
• The first 3 columns in the table are actually a Pivot Table with a Region filter. The last 3 columns are Sparklines.
  • The Column Sparkline shows total population trends over a 10 year period. The red column is the high point.
  • The Line Sparkline shows annual percentage change in population over a 10 year period. Negative points are marked in red.
  • The Win/Loss Sparkline also shows annual percentage change in population over a 10 year period. Negatives are in red.

• These charts were built using data validation lists, named ranges, conditional statements and the IFERROR, INDEX and MATCH functions.