Sunburst Chart – Show Total Values in every layer

[harishs]

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 3^rd Layer (outer layer) hasthe value in Excel sheet. I want to show overall value (total of 3^rdlayer) in 2^nd layer (mid layer) and 2^nd layer value in 1^stlayer (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.

<tbody>
[TD="bgcolor: transparent"]Years

[/TD]
[TD="bgcolor: transparent"]Qtr
[/TD]
[TD="bgcolor: transparent"]Month
[/TD]
[TD="bgcolor: transparent"]Value
[/TD]

[TD="bgcolor: transparent"]2018
[/TD]
[TD="bgcolor: transparent"]Q1
[/TD]
[TD="bgcolor: transparent"]Jan
[/TD]
[TD="bgcolor: transparent"]5%
[/TD]

[TD="bgcolor: transparent"]2018
[/TD]
[TD="bgcolor: transparent"]Q1
[/TD]
[TD="bgcolor: transparent"]Feb
[/TD]
[TD="bgcolor: transparent"]5%
[/TD]

[TD="bgcolor: transparent"]2018

[/TD]
[TD="bgcolor: transparent"]Q1
[/TD]
[TD="bgcolor: transparent"]Mar
[/TD]
[TD="bgcolor: transparent"]5%
[/TD]

[TD="bgcolor: transparent"]2018
[/TD]
[TD="bgcolor: transparent"]Q2
[/TD]
[TD="bgcolor: transparent"]Apr
[/TD]
[TD="bgcolor: transparent"]6%
[/TD]

[TD="bgcolor: transparent"]2018
[/TD]
[TD="bgcolor: transparent"]Q2
[/TD]
[TD="bgcolor: transparent"]May
[/TD]
[TD="bgcolor: transparent"]6%
[/TD]

[TD="bgcolor: transparent"]2018
[/TD]
[TD="bgcolor: transparent"]Q2
[/TD]
[TD="bgcolor: transparent"]Jun
[/TD]
[TD="bgcolor: transparent"]6%
[/TD]

</tbody>

Regards,
Harish S

 

[harishs]

Hi Expert,

Any guidance.

Regards
Harish S

 

[Twollaston]

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 3^rd Layer (outer layer) hasthe value in Excel sheet. I want to show overall value (total of 3^rdlayer) in 2^nd layer (mid layer) and 2^nd layer value in 1^stlayer (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.

<tbody>
[TD="bgcolor: transparent"]Years
[/TD]
[TD="bgcolor: transparent"]Qtr[/TD]
[TD="bgcolor: transparent"]Month[/TD]
[TD="bgcolor: transparent"]Value[/TD]

[TD="bgcolor: transparent"]2018[/TD]
[TD="bgcolor: transparent"]Q1[/TD]
[TD="bgcolor: transparent"]Jan[/TD]
[TD="bgcolor: transparent"]5%[/TD]

[TD="bgcolor: transparent"]2018[/TD]
[TD="bgcolor: transparent"]Q1[/TD]
[TD="bgcolor: transparent"]Feb[/TD]
[TD="bgcolor: transparent"]5%[/TD]

[TD="bgcolor: transparent"]2018
[/TD]
[TD="bgcolor: transparent"]Q1[/TD]
[TD="bgcolor: transparent"]Mar[/TD]
[TD="bgcolor: transparent"]5%[/TD]

[TD="bgcolor: transparent"]2018[/TD]
[TD="bgcolor: transparent"]Q2[/TD]
[TD="bgcolor: transparent"]Apr[/TD]
[TD="bgcolor: transparent"]6%[/TD]

[TD="bgcolor: transparent"]2018[/TD]
[TD="bgcolor: transparent"]Q2[/TD]
[TD="bgcolor: transparent"]May[/TD]
[TD="bgcolor: transparent"]6%[/TD]

[TD="bgcolor: transparent"]2018[/TD]
[TD="bgcolor: transparent"]Q2[/TD]
[TD="bgcolor: transparent"]Jun[/TD]
[TD="bgcolor: transparent"]6%[/TD]

</tbody>

Regards,
Harish S

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

Like this?
[TABLE="width: 329"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Years[/TD]
[TD]Qtr[/TD]
[TD]Month[/TD]
[TD]Sum of Value[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD]Q1[/TD]
[TD]Jan[/TD]
[TD="align: right"]0.05[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD]Q1[/TD]
[TD]Feb[/TD]
[TD="align: right"]0.05[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD]Q1[/TD]
[TD]Mar[/TD]
[TD="align: right"]0.05[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD]Q1 Total[/TD]
[TD][/TD]
[TD="align: right"]0.15[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD]Q2[/TD]
[TD]Apr[/TD]
[TD="align: right"]0.06[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD]Q2[/TD]
[TD]May[/TD]
[TD="align: right"]0.06[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD]Q2[/TD]
[TD]Jun[/TD]
[TD="align: right"]0.06[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD]Q2 Total[/TD]
[TD][/TD]
[TD="align: right"]0.18[/TD]
[/TR]
[TR]
[TD]2018 Total[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.33[/TD]
[/TR]
</tbody>[/TABLE]

or are you asking for something else?

 

[harishs]

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