Excel 2010 Bible

Chapter 17: Performing Magic with Array Formulas 399 Select B4:H9 and enter this array formula. Remember: To enter an array for ...

...

T he five chapters in this section deal with charts and graphics — including the new Sparkline graphics. You’ll discover how to ...

23_474877-pp03.indd 40223_474877-pp03.indd 402 3/29/10 11:45 PM3/29/10 11:45 PM ...

403 CHAPTER IN THIS CHAPTER Charting overview How Excel handles charts Embedded charts versus chart sheets The parts of a chart ...

Part III: Creating Charts and Graphics 404 Figure 18.1 shows a worksheet that contains a simple column chart that depicts a comp ...

Chapter 18: Getting Started Making Charts 405 A key point to keep in mind is that charts are dynamic. In other words, a chart se ...

Part III: Creating Charts and Graphics 406 Chart sheets When a chart is on a chart sheet, you view it by clicking its sheet tab. ...

Chapter 18: Getting Started Making Charts 407 It also contains horizontal grid lines (which correspond to the left value axis). ...

Part III: Creating Charts and Graphics 408 Creating a Chart Creating a chart is fairly simple: Make sure that your data is appr ...

Chapter 18: Getting Started Making Charts 409 FIGURE 18.4 The source data for the hands-on chart example. Tip If your chart data ...

Part III: Creating Charts and Graphics 410 FIGURE 18.5 A clustered columns chart. Note Every chart type has a set of layouts tha ...

Chapter 18: Getting Started Making Charts 411 Tip You can link the chart title to a cell so the title always displays the conten ...

Part III: Creating Charts and Graphics 412 Trying other chart types Although a clustered column chart seems to work well for thi ...

Chapter 18: Getting Started Making Charts 413 Figure 18.9 shows a few different chart type options using the customer satisfacti ...

Part III: Creating Charts and Graphics 414 Resizing a chart If your chart is an embedded chart, you can freely resize it with yo ...

Chapter 18: Getting Started Making Charts 415 Adding chart elements To add new elements to a chart (such as a title, legend, dat ...

Part III: Creating Charts and Graphics 416 Tip If you apply formatting to a chart element and decide that it wasn’t such a good ...

Chapter 18: Getting Started Making Charts 417 If you don’t want a particular embedded chart to appear on your printout, use the ...

Part III: Creating Charts and Graphics 418 FIGURE 18.11 The same data, plotted by using six chart types. On the CD This workbook ...