Excel for Marketing Managers

Demonstrating and Comparing Fractions with Charts

Comparing
Fractions
in Charts

3. Next, you need to turn off automatic calculation.
   To do this, go to Tools → Options → Calculation. Click on the radio button
   next to the word Manual. Now, after you type in the fractions that you
   want to compare, you will need to press the F9 key in order for the two
   charts to display the fractions. This will give the student an opportunity to
   guess which fraction is the larger before Excel displays the charts.


4. To make the worksheet easier to work with, for you or a student, you will
   need to protect the chart so that you can only move between the two cells
   that display the fractions you type in.

a. Select cell A1 (or whichever cell displays the fraction on the left side of

the page) and press Ctrl+1 to open the Format Cell dialog box. Click on

the Protection tab, and uncheck the box next to Locked. Check the box

next to the word Hidden. Click OK to exit.

Figure 245

Pie chart with darkened sections comparing two different fractions