Excel 2019 Bible

Part III: Creating Charts and Other Visualizations Excel provides three ways, described in the following sections, to select a p ...

Using Advanced Naming Techniques 21 When you move the mouse over a chart, a small chart tip displays the name of the chart eleme ...

Part III: Creating Charts and Other Visualizations FIGURE 21.2 Using the Chart Elements control in the Mini toolbar The Chart El ...

Chapter 21: Using Advanced Charting Techniques 21 Using the Format task pane When a chart element is selected, use the element’s ...

Part III: Creating Charts and Other Visualizations Normally, the Format task pane is docked on the right side of the window. But ...

Chapter 21: Using Advanced Charting Techniques 21 a comprehensive set of tools for chart elements, you can modify the Shape Fill ...

Part III: Creating Charts and Other Visualizations FIGURE 21.5 The Chart Area element uses No Fill, so the underlying cells are ...

Chapter 21: Using Advanced Charting Techniques 21 though, you can change the aspect ratio of the Plot Area by changing either th ...

Part III: Creating Charts and Other Visualizations The easiest way to add a chart title is to use the Chart Elements button (the ...

Chapter 21: Using Advanced Charting Techniques 21 If you move a legend manually, you may need to adjust the size of the chart’s ...

Part III: Creating Charts and Other Visualizations FIGURE 21.8 Using shapes as callouts in lieu of a legend Copying Chart Format ...

Chapter 21: Using Advanced Charting Techniques 21 Each axis has two sets of gridlines: major and minor. Major units display a la ...

Part III: Creating Charts and Other Visualizations FIGURE 21.9 The Format Axis task pane for a value axis FIGURE 21.10 These two ...

Chapter 21: Using Advanced Charting Techniques 21 The actual scale you use depends on the situation. There are no hard-and-fast ...

Part III: Creating Charts and Other Visualizations FIGURE 21.12 These charts display the same data, but the bottom chart uses a ...

Chapter 21: Using Advanced Charting Techniques 21 To adjust the tick marks displayed on an axis, click the Tick Marks section of ...

Part III: Creating Charts and Other Visualizations Modifying the category axis Figure 21.15 shows part of the Axis Options secti ...

Chapter 21: Using Advanced Charting Techniques 21 Excel chooses the way to orient the category labels, but you can override its ...

Part III: Creating Charts and Other Visualizations FIGURE 21.18 Excel determines the way to display category axis labels. Don’t ...

Chapter 21: Using Advanced Charting Techniques 21 FIGURE 21.19 This chart uses three columns of text for the category axis label ...