Excel for Marketing Managers

Demonstrating and Comparing Fractions with Charts

Comparing

Fractions

in Charts

2. Click on square dot in the bottom right corner of the chart and drag down
   and to the right so that the chart fills the entire screen.

For some reason, Excel allocates a lot of room to the white space around pie

charts. You can make the plot area of the chart take up more of the chart

area.

3. Select the Chart Area dropdown on the Chart toolbar and change the
   selection to Plot Area.

This selection will draw a new bounding box just around the pie.

4. Click on the white space inside this bounding box and drag the pie to the
   top of the chart area. Next, click on the dot in the bottom corner and drag
   down and right to make the pie fill most of the height of the worksheet.

Figure 234

Increasing plot area size

Figure 235

New bounding box eliminates

excess white area around pie