How to Add a Value to the centre of a Donut Chart
In Excel, a donut chart can be enhanced by adding a centre value to display key data, such as percentages. This guide shows how to set up a dynamic centre value for a donut chart.
Step-by-Step Instructions for Adding a centre Value
1. Create a Pivot Chart
- Go to Insert, select Pivot Chart, and create a new chart based on your data.
2. Build and Format the Donut Chart
- Right-click the chart, change it to a Donut chart, and add Data Labels to show values.
3. Insert a Slicer
- In PivotChart Analyze, insert a slicer for trained vs untrained values and resize as needed.
4. Calculate Percentage Value
- Use a simple division formula to calculate the percentage of trained vs untrained sales in a cell.
5. Add Value Inside a Shape
- Insert an oval shape, link it to the calculated percentage cell, and position it at the centre of the donut chart.
Why Use a centre Value in a Donut Chart?
Adding a centre value to a donut chart enhances data visualization by giving viewers a quick summary of key metrics, like percentages. Ideal for visually summarizing data in Excel dashboards.