O'Reilly logo

Developing Business Intelligence Apps for SharePoint by David Feldman, Jason Himmelstein

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

Chapter 23. Sparklines and Data Bars

Sparklines: Intense, Simple, Word-Sized Graphics

“For Excel 2010, we’ve implemented sparklines, 'intense, simple, word-sized graphics,’ as their inventor Edward Tufte describes them in his book, Beautiful Evidence. Sparklines help bring meaning and context to numbers being reported and, unlike a chart, are meant to be embedded into what they are describing...”

We’ll explore sparklines by creating a variant of our dashboard that shows trend over time for tickets by state using the second PivotTable. This example builds on our previous work in Part IV.

  1. Right-click on and make a copy of your existing sheet and name it Sparklines (Figure 23-1).

    Launch the Move or Copy dialog
    Figure 23-1. Launch the Move or Copy dialog
  2. Right-click on the worksheet that contains your dashboard.

  3. Select Move or Copy to show the Move or Copy menu (Figure 23-2).

  4. Check Create a copy and click OK.

    Move or Copy dialog
    Figure 23-2. Move or Copy dialog
  5. On the new copy of your dashboard, remove full name from the second PivotTable.

  6. Add State from the People dimension (Figure 23-3).

  7. Tweak the column width or slicer position as required.

    Pivoting by State
    Figure 23-3. Pivoting by State
  8. To add a sparkline, select the cell, you’d like to insert your sparkline.

  9. Go to ...

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