Excel for Marketing Managers

Demonstrating and Comparing Fractions with Charts

Comparing
Fractions
in Charts

b. Select cell B2. Type Ctrl+1 to display the Format Cells dialog. In the

Number tab under the Category list, choose the option for Fraction. If

you will only be displaying fractions such as 1/2, 1/3, or 3/8, then it is

OK to use the option for Up to 1 Digit. If you might be displaying 1/16

or 1/32, then you might want to use the option for up to two digits.

2. In cell B3, enter the following formula: =1-B2
   A pie chart must be comprised of 100% or 1. As you change the fraction in
   B2, the formula in B3 will ensure that the total value for the pie chart adds
   up to 100%.

Figure 226

Entering a decimal value to be

represented as a fraction

Figure 227

Selecting number of

digits for fractions