Sunburst chart with percentages of total dollar value

skylinekiller

New Member
Joined
May 3, 2004
Messages
48
I am trying to make a sunburst chart with 3 to 4 deep categories.
The core of the chart, I want to show the total budget granted ($20,400,000), then the next level I want it to be expense type, the third level is the funding code, and the last level show the percentage of the total budget granted.




Test Sunburst.xlsx
ABCDEFGHIJKLMNOPQRST
1
2
3
4
5
6
7
8Funding Code
92023 Requested2023 Funds receivedCommercial2010$ 2,500,000.008.16
10$ 30,000,000.00$ 20,400,000.002040$ 1,500,000.000.07
113040$ 900,000.000.04
12Personal3010$ 3,500,000.000.17
133080$ 500,000.000.02
143400$ 1,500,000.000.07
15Misc3010$ 5,000,000.000.25
163080$ 3,000,000.000.15
173400$ 2,000,000.000.10
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
TEST
Cell Formulas
RangeFormula
G9G9=C10/F9
G10G10=F10/C10
G11G11=F11/C10
G12G12=F12/C10
G13G13=F13/C10
G14G14=F14/C10
G15G15=F15/C10
G16G16=F16/C10
G17G17=F17/C10
 

Attachments

  • test.jpg
    test.jpg
    170.9 KB · Views: 13

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,215,123
Messages
6,123,183
Members
449,090
Latest member
bes000

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