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
Highlighted
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
my chart can not smooth the points
inadotb in Excel on
2 Replies
working on a series
MBARRY95 in Excel on
2 Replies