Sunburst Chart – Show Total Values in every layer

harishs

Board Regular
Joined
Jul 3, 2016
Messages
50
Office Version
  1. 365
  2. 2016
Platform
  1. Windows


Hi Expert,
I have a challenge in completing Sunburst Chartfor one my dashboard and I am stuck… browsed thru onlnsomesolutions but somehow I am unable to figure it out. So seeking expertadvise.


I have created 3 layer Sunburst Chart, my 3rd Layer (outer layer) hasthe value in Excel sheet. I want to show overall value (total of 3rdlayer) in 2nd layer (mid layer) and 2nd layer value in 1stlayer (inner layer).

Eg: I have 4 columns, Now my Outlayer (month) should show values of each month, midlayer should show Q1 total value of months (Jan+Feb+Mar) and inner layer shouldshow total of Q1 & Q2.


Years

Qtr
Month
Value
2018
Q1
Jan
5%
2018
Q1
Feb
5%
2018

Q1
Mar
5%
2018
Q2
Apr
6%
2018
Q2
May
6%
2018
Q2
Jun
6%

<tbody>
</tbody>


Regards,
Harish S

 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.


Hi Expert,
I have a challenge in completing Sunburst Chartfor one my dashboard and I am stuck… browsed thru onlnsomesolutions but somehow I am unable to figure it out. So seeking expertadvise.


I have created 3 layer Sunburst Chart, my 3rd Layer (outer layer) hasthe value in Excel sheet. I want to show overall value (total of 3rdlayer) in 2nd layer (mid layer) and 2nd layer value in 1stlayer (inner layer).

Eg: I have 4 columns, Now my Outlayer (month) should show values of each month, midlayer should show Q1 total value of months (Jan+Feb+Mar) and inner layer shouldshow total of Q1 & Q2.


Years
QtrMonthValue
2018Q1Jan5%
2018Q1Feb5%
2018
Q1Mar5%
2018Q2Apr6%
2018Q2May6%
2018Q2Jun6%

<tbody>
</tbody>


Regards,
Harish S


I'm not clear on what you are wanting. Are you saying you want subtotals?

Like this?
YearsQtrMonthSum of Value
2018Q1Jan0.05
2018Q1Feb0.05
2018Q1Mar0.05
2018Q1 Total0.15
2018Q2Apr0.06
2018Q2May0.06
2018Q2Jun0.06
2018Q2 Total0.18
2018 Total0.33
Grand Total0.33

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

or are you asking for something else?
 
Upvote 0
Hi Twollaston,

Yes, this is what I am looking in Sunburst Chart. Values to reflect in all 3 layers.

Currently, after browsing hours togehter I found an alternate solution, manual work. Use 3 diff Pie Charts & place it on each other & Group it. But still looking forward to use Suburst Chart.

Regards,
Harish S
 
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,104
Members
448,548
Latest member
harryls

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