Publishers of technology books, eBooks, and videos for creative people

Home > Articles > Productivity

  • Print
  • + Share This
From the author of Excel Feature: Sparklines

Excel Feature: Sparklines

Excel 2010 has a new form of chart. (That's form, not style.) Sparklines are tiny charts that summarize data. Unlike normal charts, which are floating, resizable objects, sparklines are displayed in cells, visually linking them with the data they're summarizing. A sparkline can use any of three formats: line, column, or win/loss. As with other charts, if you edit the data on which sparklines are based, the sparklines automatically update. Whether you'll find sparklines indispensable or merely a software oddity depends on your willingness to experiment and the acuity of your eyesight.

Although there are only three sparkline styles, you can customize sparkline formatting by setting options on the Design tab (see Figure 8). You can modify the formatting for an entire set or for individual sparklines.

Figure 8 You can customize the formatting for selected sparklines (in column E, in this example) by selecting options from the Design tab.

  • + Share This
  • 🔖 Save To Your Account