Excel 2010 Bible

Chapter 20: Visualizing Data Using Conditional Formatting 499 FIGURE 20.18 The sum is displayed only when all four values have b ...

Part III: Creating Charts and Graphics 500 FIGURE 20.20 This range uses data bars, color scales, and icon sets. Copying cells th ...

Chapter 20: Visualizing Data Using Conditional Formatting 501 Locating cells that contain conditional formatting You can’t tell, ...

...

503 CHAPTER Creating Sparkline Graphics IN THIS CHAPTER An introduction to the new Sparkline graphics feature How to add Sparkli ...

Part III: Creating Charts and Graphics 504 Sparkline Types Excel 2010 supports three types of Sparklines. Figure 21.1 shows exam ...

Chapter 21: Creating Sparkline Graphics 505 Creating Sparklines Figure 21.2 shows some data to be summarized with Sparklines. To ...

Part III: Creating Charts and Graphics 506 The Sparklines are linked to the data, so if you change any of the values in the data ...

Chapter 21: Creating Sparkline Graphics 507 Figure 21.4 shows column Sparklines for the precipitation data. FIGURE 21.4 Column S ...

Part III: Creating Charts and Graphics 508 Handling hidden or missing data By default, if you hide rows or columns that are used ...

Chapter 21: Creating Sparkline Graphics 509 Highlighting certain data points Use the commands in the Sparkline Tools ➪ Design ➪ ...

Part III: Creating Charts and Graphics 510 Figure 21.8 shows two groups of Sparklines. The group at the top uses the default axi ...

Chapter 21: Creating Sparkline Graphics 511 FIGURE 21.9 Sparklines display the number of pages read per month. FIGURE 21.10 Usin ...

Part III: Creating Charts and Graphics 512 FIGURE 21.11 The axis in the Sparklines represents the goal. Specifying a Date Axis N ...

Chapter 21: Creating Sparkline Graphics 513 FIGURE 21.13 After specifying a date axis, the Sparkline shows the values accurately ...

Part III: Creating Charts and Graphics 514 Displaying a Sparkline for a Dynamic Range The example in this section describes how ...

Chapter 21: Creating Sparkline Graphics 515 I started by creating a dynamic range name. Here’s how: Choose Formulas ➪ Defined N ...

...

517 CHAPTER Enhancing Your Work with Pictures and Drawings IN THIS CHAPTER Inserting and customizing Shapes An overview of Smart ...

Part III: Creating Charts and Graphics 518 Inserting a Shape You can add a Shape to a worksheet’s draw layer by choosing Insert ...