Skip to content

Instantly share code, notes, and snippets.

@rejochandran
Last active June 9, 2021 08:57
Show Gist options
  • Save rejochandran/0a67a3467cc891767f1cc32a5939b435 to your computer and use it in GitHub Desktop.
Save rejochandran/0a67a3467cc891767f1cc32a5939b435 to your computer and use it in GitHub Desktop.
Sunburst Sample XML
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<cx:chartSpace xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:cx="http://schemas.microsoft.com/office/drawing/2014/chartex">
<cx:chartData>
<cx:externalData r:id="rId1" cx:autoUpdate="0" />
<cx:data id="0">
<cx:strDim type="cat">
<cx:f>Sheet1!$A$2:$C$17</cx:f>
<cx:lvl ptCount="16">
<cx:pt idx="0">Leaf 1</cx:pt>
<cx:pt idx="1">Leaf 2</cx:pt>
<cx:pt idx="2">Leaf 3</cx:pt>
<cx:pt idx="3">Leaf 4</cx:pt>
<cx:pt idx="4">Leaf 5</cx:pt>
<cx:pt idx="5"></cx:pt>
<cx:pt idx="6"></cx:pt>
<cx:pt idx="7">Leaf 8</cx:pt>
<cx:pt idx="8"></cx:pt>
<cx:pt idx="9">Leaf 10</cx:pt>
<cx:pt idx="10">Leaf 11</cx:pt>
<cx:pt idx="11">Leaf 12</cx:pt>
<cx:pt idx="12">Leaf 13</cx:pt>
<cx:pt idx="13">Leaf 14</cx:pt>
<cx:pt idx="14">Leaf 15</cx:pt>
<cx:pt idx="15"></cx:pt>
</cx:lvl>
<cx:lvl ptCount="16">
<cx:pt idx="0">Stem 1</cx:pt>
<cx:pt idx="1">Stem 1</cx:pt>
<cx:pt idx="2">Stem 1</cx:pt>
<cx:pt idx="3">Stem 2</cx:pt>
<cx:pt idx="4">Stem 2</cx:pt>
<cx:pt idx="5">Leaf 6</cx:pt>
<cx:pt idx="6">Leaf 7</cx:pt>
<cx:pt idx="7">Stem 3</cx:pt>
<cx:pt idx="8">Leaf 9</cx:pt>
<cx:pt idx="9">Stem 4</cx:pt>
<cx:pt idx="10">Stem 4</cx:pt>
<cx:pt idx="11">Stem 5</cx:pt>
<cx:pt idx="12">Stem 5</cx:pt>
<cx:pt idx="13">Stem 6</cx:pt>
<cx:pt idx="14">Stem 6</cx:pt>
<cx:pt idx="15">Leaf 16</cx:pt>
</cx:lvl>
<cx:lvl ptCount="16">
<cx:pt idx="0">Branch 1</cx:pt>
<cx:pt idx="1">Branch 1</cx:pt>
<cx:pt idx="2">Branch 1</cx:pt>
<cx:pt idx="3">Branch 1</cx:pt>
<cx:pt idx="4">Branch 1</cx:pt>
<cx:pt idx="5">Branch 1</cx:pt>
<cx:pt idx="6">Branch 1</cx:pt>
<cx:pt idx="7">Branch 2</cx:pt>
<cx:pt idx="8">Branch 2</cx:pt>
<cx:pt idx="9">Branch 2</cx:pt>
<cx:pt idx="10">Branch 2</cx:pt>
<cx:pt idx="11">Branch 3</cx:pt>
<cx:pt idx="12">Branch 3</cx:pt>
<cx:pt idx="13">Branch 3</cx:pt>
<cx:pt idx="14">Branch 3</cx:pt>
<cx:pt idx="15">Branch 3</cx:pt>
</cx:lvl>
</cx:strDim>
<cx:numDim type="size">
<cx:f>Sheet1!$D$2:$D$17</cx:f>
<cx:lvl ptCount="16" formatCode="General">
<cx:pt idx="0">22</cx:pt>
<cx:pt idx="1">12</cx:pt>
<cx:pt idx="2">18</cx:pt>
<cx:pt idx="3">87</cx:pt>
<cx:pt idx="4">88</cx:pt>
<cx:pt idx="5">17</cx:pt>
<cx:pt idx="6">14</cx:pt>
<cx:pt idx="7">25</cx:pt>
<cx:pt idx="8">16</cx:pt>
<cx:pt idx="9">24</cx:pt>
<cx:pt idx="10">89</cx:pt>
<cx:pt idx="11">16</cx:pt>
<cx:pt idx="12">19</cx:pt>
<cx:pt idx="13">86</cx:pt>
<cx:pt idx="14">23</cx:pt>
<cx:pt idx="15">21</cx:pt>
</cx:lvl>
</cx:numDim>
</cx:data>
</cx:chartData>
<cx:chart>
<cx:title pos="t" align="ctr" overlay="0" />
<cx:plotArea>
<cx:plotAreaRegion>
<cx:series layoutId="sunburst" uniqueId="{D5C87836-4BFB-4617-B29A-BE9E77F7D26B}">
<cx:tx>
<cx:txData>
<cx:f>Sheet1!$D$1</cx:f>
<cx:v>Series1</cx:v>
</cx:txData>
</cx:tx>
<cx:dataLabels pos="ctr">
<cx:visibility seriesName="0" categoryName="1" value="0" />
</cx:dataLabels>
<cx:dataId val="0" />
</cx:series>
</cx:plotAreaRegion>
</cx:plotArea>
</cx:chart>
</cx:chartSpace>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment