xxvii
Contents
Chapter 22: Creating Sparkline Graphics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 523
Sparkline Types ................................................................................................. 523
Creating Sparklines ............................................................................................ 525
Customizing Sparklines ...................................................................................... 527
Sizing Sparkline cells ................................................................................. 528
Handling hidden or missing data ................................................................ 528
Changing the Sparkline type ...................................................................... 529
Changing Sparkline colors and line width .................................................... 529
Highlighting certain data points ................................................................ 529
Adjusting Sparkline axis scaling ................................................................. 530
Faking a reference line .............................................................................. 531
Specifying a Date Axis ....................................................................................... 533
Auto-Updating Sparklines ................................................................................... 535
Displaying a Sparkline for a Dynamic Range ........................................................ 535Chapter 23: Visualizing with Custom Number Formats and Shapes. . . . . . . . . . . . . . . . 537
Visualizing with Number Formatting ................................................................... 537
Doing basic number formatting .................................................................. 537
Using shortcut keys to format numbers .............................................. 538
Using the Format Cells dialog box to format numbers .......................... 539
Getting fancy with custom number formatting ............................................ 540
Formatting numbers in thousands and millions ................................... 542
Hiding and suppressing zeros ............................................................. 543
Applying custom format colors ........................................................... 544
Formatting dates and times ............................................................... 545
Using symbols to enhance reporting ........................................................... 546
Using Shapes and Icons as Visual Elements .......................................................... 550
Inserting a shape ...................................................................................... 550
Inserting SVG icon graphics ....................................................................... 551
Formatting shapes and icons ...................................................................... 552
Enhancing Excel reports with shapes .......................................................... 554
Creating visually appealing containers with shapes ............................. 554
Layering shapes to save space ............................................................ 556
Constructing your own infographic widgets with shapes ...................... 556
Creating dynamic labels ............................................................................. 557
Creating linked pictures............................................................................. 558
Using SmartArt and WordArt .............................................................................. 561
SmartArt basics......................................................................................... 561
WordArt basics .......................................................................................... 562
Working with Other Graphics Types ..................................................................... 563
About graphics files ................................................................................... 563
Inserting screenshots ................................................................................ 564
Displaying a worksheet background image .................................................. 564
Using the Equation Editor ................................................................................... 565