Home

Donut/Doughnut Chart - Multiple Series

%3CLINGO-SUB%20id%3D%22lingo-sub-310192%22%20slang%3D%22en-US%22%3EDonut%2FDoughnut%20Chart%20-%20Multiple%20Series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310192%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20doughnut%20chart%20with%20multiple%20series%20(represented%20by%20multiple%20rings%20-%20see%20charts%20below).%20Each%20ring%20is%20divided%20into%206%2C%20the%20colour%20of%20which%20corresponds%20to%20one%20of%20three%20options%20(yes%2C%20maybe%20and%20no).%20I%20therefore%20want%20the%20colour%20of%20the%20chart%20to%20represent%20this%20clearly%20(green%2C%20yellow%20and%20red)%2C%20making%20each%20ring%20comparable%20-%20i.e.%20so%20that%20the%20entire%20chart%20is%20made%20up%20of%20only%20three%20colours.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20format%20the%20legend%20entry%20to%20edit%20the%20colours%2C%20it%20only%20applies%20the%20changes%20to%20the%20inner%20ring%2Fthe%20first%20series.%20I%20am%20able%20to%20manually%20edit%20the%20colour%20of%20every%20other%20ring%20segment%2C%20however%20with%20a%20lot%20more%20data%20to%20add%20this%20will%20take%20a%20very%20long%20time%20and%20mean%20that%20I%20am%20no%20able%20to%20easily%20edit%20it%20should%20I%20wish%20to%20change%20the%20colour%20again.%20I%20imagine%20there%20is%20a%20way%20to%20do%20this%20in%20one%20simple%20step%2C%20however%20am%20unable%20to%20find%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20make%20sense%3F%20Any%20help%20would%20be%20greatly%20appreciated.%20Please%20let%20me%20know%20if%20I%20need%20to%20make%20this%20clearer%2Fexplin%20further.%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChart%201%26nbsp%3B-%20the%20automatically%20generated%20chart%20where%20only%20the%20colours%20of%20the%20inner%20ring%20have%20changed%20as%20I%20have%20edited%20them.%26nbsp%3B%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%2F64891i3060D0403EB7C63F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22chart%201.jpg%22%20title%3D%22chart%201.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChart%202%20-%26nbsp%3B%3CSPAN%3EI%20have%20manually%20edited%20this%20chart%20to%20show%20how%20I%20want%20the%20chart%20to%20look%20-%20i.e.%20I%20want%20any%20colours%20that%20I%20change%20to%20apply%20to%20all%20series%3C%2FSPAN%3E%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%2F64892iECB24BCCA3BE8717%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22chart%202.jpg%22%20title%3D%22chart%202.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-310192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edonut%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edoughnut%20chart%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormatting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
lwilkinson92
Occasional Visitor

I have created a doughnut chart with multiple series (represented by multiple rings - see charts below). Each ring is divided into 6, the colour of which corresponds to one of three options (yes, maybe and no). I therefore want the colour of the chart to represent this clearly (green, yellow and red), making each ring comparable - i.e. so that the entire chart is made up of only three colours.

 

When I format the legend entry to edit the colours, it only applies the changes to the inner ring/the first series. I am able to manually edit the colour of every other ring segment, however with a lot more data to add this will take a very long time and mean that I am no able to easily edit it should I wish to change the colour again. I imagine there is a way to do this in one simple step, however am unable to find it.

 

Does this make sense? Any help would be greatly appreciated. Please let me know if I need to make this clearer/explin further. Thanks!

 

Chart 1 - the automatically generated chart where only the colours of the inner ring have changed as I have edited them. 

chart 1.jpg

 

Chart 2 - I have manually edited this chart to show how I want the chart to look - i.e. I want any colours that I change to apply to all series

chart 2.jpg

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies