Excel 2010 Bible

Chapter 19: Learning Advanced Charting 439 Tip If you find these chart tips annoying, you can turn them off. Choose File ➪ Optio ...

Part III: Creating Charts and Graphics 440 FIGURE 19.2 Using the Chart Element drop-down control to select a chart element. If y ...

Chapter 19: Learning Advanced Charting 441 Note When a single data point is selected, the Chart Element control will display the ...

Part III: Creating Charts and Graphics 442 FIGURE 19.3 Use the Format dialog box to set the properties of a selected chart eleme ...

Chapter 19: Learning Advanced Charting 443 Modifying the Chart Area The Chart Area is an object that contains all other elements ...

Part III: Creating Charts and Graphics 444 Modifying the Plot Area The Plot Area is the part of the chart that contains the actu ...

Chapter 19: Learning Advanced Charting 445 Tip Changing the size and position of the Plot Area can have a dramatic effect on the ...

Part III: Creating Charts and Graphics 446 The chart title or any of the axis titles can also use a cell reference. For example, ...

Chapter 19: Learning Advanced Charting 447 In some cases, you may prefer to omit the legend and use callouts to identify the dat ...

Part III: Creating Charts and Graphics 448 Cross-Reference For more information about using chart templates, see “Creating Chart ...

Chapter 19: Learning Advanced Charting 449 FIGURE 19.8 These options are available for a Value Axis. Adjusting the scale of a va ...

Part III: Creating Charts and Graphics 450 The actual scale that you use depends on the situation. There are no hard-and-fast ru ...

Chapter 19: Learning Advanced Charting 451 FIGURE 19.11 These charts display the same data, but the right chart uses a logarithm ...

Part III: Creating Charts and Graphics 452 Excel lets you position the axis labels at three different locations: Next to Axis, H ...

Chapter 19: Learning Advanced Charting 453 FIGURE 19.14 These options are available for a category axis. FIGURE 19.15 Excel dete ...

Part III: Creating Charts and Graphics 454 FIGURE 19.16 Changing the Interval between Labels setting makes labels display horizo ...

Chapter 19: Learning Advanced Charting 455 FIGURE 19.18 Overriding the Excel time-based category axis. Working with Data Series ...

Part III: Creating Charts and Graphics 456 You can make changes to a data series by using options on the Ribbon or from the Form ...

Chapter 19: Learning Advanced Charting 457 FIGURE 19.19 This chart needs a new data series. Tip If the chart was originally made ...

Part III: Creating Charts and Graphics 458 If your chart is on a chart sheet, you need to use one of the two methods described n ...