Excel 2010 Bible

Chapter 18: Getting Started Making Charts 419 The radar chart (lower right) is clearly inappropriate for this data. People aren’ ...

Part III: Creating Charts and Graphics 420 The same data, in the form of a stacked column chart, is shown in Figure 18.13. This ...

Chapter 18: Getting Started Making Charts 421 The data is plotted with a 3-D clustered column chart in Figure 18.15. The name is ...

Part III: Creating Charts and Graphics 422 Bar A bar chart is essentially a column chart that has been rotated 90 degrees clockw ...

Chapter 18: Getting Started Making Charts 423 Line Line charts are often used to plot continuous data and are useful for identif ...

Part III: Creating Charts and Graphics 424 FIGURE 18.19 This line chart displays three series. FIGURE 18.20 This 3-D line chart ...

Chapter 18: Getting Started Making Charts 425 Caution The values used in a pie chart must all be positive numbers. If you create ...

Part III: Creating Charts and Graphics 426 FIGURE 18.22 A bar of pie chart that shows detail for one of the pie slices. XY (scat ...

Chapter 18: Getting Started Making Charts 427 On the CD A workbook that contains the charts in this section is available on the ...

Part III: Creating Charts and Graphics 428 FIGURE 18.25 A stacked area chart. On the CD A workbook that contains the charts in t ...

Chapter 18: Getting Started Making Charts 429 Doughnut A doughnut chart is similar to a pie chart, with two differences: It has ...

Part III: Creating Charts and Graphics 430 FIGURE 18.28 Using a stacked column chart is a better choice. Radar Radar charts are ...

Chapter 18: Getting Started Making Charts 431 FIGURE 18.29 Plotting ski sales using a radar chart with 12 categories and 2 serie ...

Part III: Creating Charts and Graphics 432 FIGURE 18.31 These radar charts depict the red, green, and blue contributions for eac ...

Chapter 18: Getting Started Making Charts 433 FIGURE 18.32 A surface chart. Bubble Think of a bubble chart as an XY chart that c ...

Part III: Creating Charts and Graphics 434 FIGURE 18.33 A bubble chart. FIGURE 18.34 This bubble chart depicts a mouse. Figure 1 ...

Chapter 18: Getting Started Making Charts 435 depict the difference between the opening and closing price. A black up-bar indica ...

Part III: Creating Charts and Graphics 436 FIGURE 18.36 Plotting temperature data with a stock chart. Learning More This chapter ...

437 CHAPTER Learning Advanced Charting IN THIS CHAPTER Understanding chart customization Changing basic chart elements Working w ...

Part III: Creating Charts and Graphics 438 Excel provides three ways, described in the following sections, to select a particula ...