Excel 2019 Bible

(singke) #1

Chapter 21: Using Advanced Charting Techniques


21


though, you can change the aspect ratio of the Plot Area by changing either the height or
the width.

Figure 21.6 shows a chart in which the Plot Area was resized to make room for an inserted
shape that contains text.

FIGURE 21.6
Reducing the size of the Plot Area makes room for the shape.

In some cases, the size of the Plot Area changes automatically when you adjust other ele-
ments of your chart. For example, if you add a legend to a chart, the size of the Plot Area
may be reduced to accommodate the legend.

Changing the size and position of the Plot Area can have a dramatic effect on the overall look of your chart. When
you’re fine-tuning a chart, you’ll probably want to experiment with various sizes and positions for the Plot Area.


Working with Titles in a Chart
A chart can have several different types of titles:

■ (^) Chart title
■ Category axis title
■ (^) Value axis title
■ Secondary category axis title
■ (^) Secondary value axis title
■ Depth axis title (for true 3-D charts)
The number of titles that you can use depends on the chart type. For example, a pie chart
supports only a chart title because it has no axes.

Free download pdf