How to Design a Doughnut Chart with Percentages in Excel

The doughnut chart is a great tool for visualizing data shares and distributions. In this tutorial, we’ll show you how to customize a doughnut chart design in Excel. Learn to add percentages to chart sectors and choose the best presentation style. By following these instructions, you’ll be able to quickly and easily create your own customized charts with a more functional and attractive design.



Personalize Your Doughnut Chart with Dynamic Design

Watch this video to the end to learn how to personalize your chart with a fresh design. Discover how to change the gradient fill colors of segments, fonts, and data slice styles as control elements. You’ll also learn how to add percentage labels to the chart segments.

In this data visualization tutorial in Excel, you’ll learn to:

  1. Create a visualization panel template.
  2. Build smart and pivot tables based on source data.
  3. Use dynamic sampling formulas for charts from pivot tables.
  4. Calculate percentages for chart segments.
  5. Create a pie chart template with percentages in Excel.
  6. Customize a doughnut chart into a functional design with percentages.
  7. Choose a color scheme for chart segments.
  8. Add percentage labels to a pie chart.
  9. Create a readable legend from formulas and shapes.
  10. Display total values.
  11. Create a control panel using data slicers.
  12. Test the template and resolve potential errors.
Design Doughnut Chart with Percentages

Download Customized Doughnut Chart Template in Excel download file

This template is part of a multifunctional mini CRM dashboard in Excel.

CRM Template with Pivot Charts

Now, look at data distribution visualization in Excel from a new perspective. This will help you create more informative and presentable reports with interactive capabilities.


en ru