Home

Automatic coloring sunburst chart

%3CLINGO-SUB%20id%3D%22lingo-sub-783566%22%20slang%3D%22en-US%22%3EAutomatic%20coloring%20sunburst%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783566%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20way%20to%20color%20automatic%20cells%20in%20sunburst%20chart%20from%20set%20data%20from%20another%20cells.%20Can%20you%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20840px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125273i4FAD18D9BF27CB22%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22excel.jpg%22%20title%3D%22excel.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-783566%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EColor%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784447%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20coloring%20sunburst%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385616%22%20target%3D%22_blank%22%3E%40stefan645%3C%2FA%3E%26nbsp%3B-%3C%2FP%3E%3CP%3EThis%20should%20get%20you%20close%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125319i0AB86EF27105AB17%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.PNG%22%20title%3D%221.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20did%20have%20to%20step%20into%20'B'%20change%20the%20fill%20to%20'no%20fill'.%20Seems%20like%20%5BRevenue%5D%20controls%20the%20weight%20of%20the%20graph%20where%20A%3AE%20controls%20the%20hierarchy.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-785335%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20coloring%20sunburst%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-785335%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F303863%22%20target%3D%22_blank%22%3E%40ChrisMendoza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
stefan645
New Contributor

Hello!

I am looking for way to color automatic cells in sunburst chart from set data from another cells. Can you help me?

 

 

excel.jpg

 

 

 

2 Replies

@stefan645 -

This should get you close:

1.PNG

I did have to step into 'B' change the fill to 'no fill'. Seems like [Revenue] controls the weight of the graph where A:E controls the hierarchy.

@ChrisMendoza 

Thank you!!!