Totals in Donut Pie Chart

A

adamjon92

New Member
Joined
Dec 8, 2015
Messages
22
Hello!

I'm using a donut pie chart in excel for the first time and I was wondering if there was any way to enter the total in the middle of it other than by manually using a text box. For example, if I have 20 on the left side of the pie chart and 30 on the right side of the pie chart, I want it to show 50 in the middle of it. I have 30 different donut pie charts so I'd prefer not having to go through and manually change each of them.


Thanks in advance!

Adam
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
You must log in or register to reply here.

Similar threads

T
  • Question Question
Colour tiered donut chart based on value
Replies
0
Views
241
TomMacca52
T
A
  • Question Question
Building a nested chart using a pivot table
Replies
1
Views
357
AnthoHead
A
S
  • Question Question
Excel Pie chart - Specifying colour of label based on value
Replies
0
Views
279
scotthannaford1973
S
gravanoc
  • Question Question
Doughnut chart in Gauge chart not always set to correct axis group
Replies
0
Views
415
gravanoc
gravanoc
R
  • Solved
Custom Chart template when using slicer
Replies
2
Views
411
RodneyW
R

Forum statistics

Threads
1,223,908
Messages
6,175,307
Members
452,633
Latest member
DougMo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top