Ms Office Tune Up

In earlier Figure, I exploded one of the pie chart slices and then added a shape with some explanatory data about the composition of the Others slice. In most pie charts, you use an “Others” slice because the components data that makes up this item are too small to show properly on the pie chart. That is, the slices would be so thin that they’d be hard to pick out from the surrounding slices.

If you want others to see the data represented by an “Others” slice, Excel offers another pie chart type that’s ideal: The Bar of Pie type. With this chart type, the smallest data items are gathered into a single slice, as before, but then the separate items that comprise that slice are displayed in a separated stacked bar marker.

To create a Bar of Pie chart, select your data, choose Insert, Pie, Bar of Pie. Figure 1 shows an example.

Figure 1 A Bar of Pie chart shows the data series’ small val­ues in a separate stacked bar marker.

Technorati Tags: chart small values, bar pie chart, excel 2007

Popularity: 6% [?]