Excel for Marketing Managers

Demonstrating and Comparing Fractions with Charts

Comparing

Fractions

in Charts

Using the Application..............................................................................................................

Select the cell containing the fraction in the upper left corner of the worksheet.
Type any fraction here and the pie chart will redraw with that fraction of the
circle highlighted.

Excel Extras

Pie Chart with Only One Section Filled in

It is also possible to build a pie chart with four equal wedges and only one
wedge filled in. Base the chart on a series with four cells, each one containing
0.25. You will have to repeat the steps to delete the data labels for the second,
third, and fourth ranges. You will have to individually format the second, third,
and fourth slices to change their color to white.

Figure 242

Typing a fraction in the

target cell causes the pie

chart to redraw to

represent that fraction