O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding sparklines

Sparklines are simple and fun conditional formatting tools that make it easy for you to show at a glance what the data trend is in the values on your worksheet. You can customize your sparklines so that they appear in different colors and styles.

Excel 2013 offers three types of sparklines: Line, Column, and Win/Loss. The Line option displays your data as a small line chart. The Column sparkline format shows your data as comparison values displayed as a small bar chart. The Win/Loss option displays values as a sequence of colored dashes that clearly indicate the high and low points in your data.

Create sparklines

  1. Select the cells that you want to summarize.

  2. Click the Insert tab.

  3. In the Sparklines group, click the type ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required