Software

Differentiate pie slices with Excel's Bar Of Pie chart option

Too many tiny slices? One way to make your Excel chart more coherent is to use the Bar Of Pie chart option. The bar of pie chart displays the tiny pie slices into a horizontal bar chart so they are easier to see and label.

If you've ever tried to label an Excel pie chart where most of the chart featured two huge slices, you may have found that the rest of the slices were squeezed into such a small part of the pie that you could hardly see them. One way to make your chart more coherent is to use the Bar Of Pie chart option. The bar of pie chart displays the tiny pie slices in a horizontal bar chart so they are easier to see and label.

Learn how to use the Bar Of Pie chart option by following these steps:

  1. In A1, type Customer 1.
  2. In A2, type Customer 2.
  3. In A3, type Customer 3.
  4. In A4, type Customer 4.
  5. In A5, type Customer 5.
  6. In B1, enter 100.
  7. In B2, enter 10.
  8. In B3, enter 12.
  9. In B4, enter 20.
  10. In B5, enter 200.
  11. Select A1:B5.
  12. Click the Chart Wizard button.
  13. Select Pie under Chart Type.
  14. Click Bar Of Pie (it is the last option in the second row).
  15. Click Next twice.
  16. Click the Legend tab.
  17. Clear the Show Legend check box.
  18. Click Next and then click Finish.
  19. Right-click the chart.
  20. Select Format Data Series.
  21. Click the Options tab.
  22. Select Value From Split Series By drop-down list.
  23. Enter 50 in the Second Plot Contains All Values Less Than box.
  24. Click the Data Labels tab.
  25. Click the Category Name check box.
  26. Clear the Series Name check box, if necessary.
  27. Click the Percentage check box, then click OK.
  28. Right-click a data label in the chart.
  29. Select Format Data Labels.
  30. Click the Font tab and change the font size to 8, then click OK.

Miss an Excel tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks