Excel for Marketing Managers

Demonstrating and Comparing Fractions with Charts

Comparing
Fractions
in Charts

Customizing a Chart

By default, Excel will draw the chart to take up a certain amount of space on

the worksheet. If you are going to be projecting this worksheet onto a screen,

you will want the chart to be as large as possible. The chart is comprised of the

pie, surrounded by white space and then a black border.

1. Click inside of the white space and eight black handles will appear on the
   border. You can now click and drag on the white space to move the chart up
   to just below the fraction.

Caution!

If you really want to go overboard, you can also turn off the Formula and Status

bars and hide most of the toolbars. However, these changes will globally affect all

future workbooks, so I don’t really recommend this!

On the View menu, unselect both Formula bar and Status bar. In the View →

Toolbars menu, unselect any checked toolbars.

Figure 233

Moving the

chart