Excel 2019 Bible

Chapter 20: Getting Started with Excel Charts 20 Chart sheets You can move an embedded chart to its own chart sheet so that you ...

Part III: Creating Charts and Other Visualizations Parts of a chart A chart is made up of many different elements, and all of th ...

Chapter 20: Getting Started with Excel Charts 20 The chart has a horizontal axis, known as the category axis. This axis represen ...

Part III: Creating Charts and Other Visualizations FIGURE 20.6 A pie chart Chart limitations As with most features in Excel, cha ...

Chapter 20: Getting Started with Excel Charts 20 FIGURE 20.7 A 3-D column chart Basic Steps for Creating a Chart Creating a char ...

Part III: Creating Charts and Other Visualizations Click the Insert tab and then click a Chart icon in the Charts group. The ic ...

Chapter 20: Getting Started with Excel Charts 20 FIGURE 20.10 A column chart with two data series The orientation of the data ha ...

Part III: Creating Charts and Other Visualizations Changing the chart type After you’ve created a chart, you can easily change t ...

Chapter 20: Getting Started with Excel Charts 20 FIGURE 20.12 The Change Chart Type dialog box Adding and deleting chart element ...

Part III: Creating Charts and Other Visualizations Excel inserts a title with the text “Chart Title.” Click the text and replace ...

Chapter 20: Getting Started with Excel Charts 20 Excel provides two ways to format and customize individual chart elements. Each ...

Part III: Creating Charts and Other Visualizations Before you can modify a chart, you must activate it. To activate an embedded ...

Chapter 20: Getting Started with Excel Charts 20 FIGURE 20.15 Use the Move Chart dialog box to move an embedded chart to a chart ...

Part III: Creating Charts and Other Visualizations Moving and deleting chart elements Some elements within a chart can be moved: ...

Chapter 20: Getting Started with Excel Charts 20 Exploring the Format Task Pane The Format task pane can be a bit deceiving. It ...

Part III: Creating Charts and Other Visualizations Why rename a chart? If a worksheet has many charts, you may prefer to activat ...

Chapter 20: Getting Started with Excel Charts 20 ■ (^) Making relative comparisons: A common pie chart can depict relative propo ...

Part III: Creating Charts and Other Visualizations FIGURE 20.16 The same data, plotted by using six chart types The radar chart ...

Chapter 20: Getting Started with Excel Charts 20 The remainder of this chapter contains more information about the various Excel ...

Part III: Creating Charts and Other Visualizations FIGURE 20.18 This stacked column chart displays sales by product and depicts ...