• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Category labels in Doughnut charts

US4Bcouk

New Member
Hi awesome people!
Got asked an interesting question yesterday...

Is it possible to have the category labels in a doughnut chart to automatically match the shape of the sector to which they belong? I know we're able to change their angle, but that does it the same for all, what I've been asked is whether they can "flow round" within the segment - like the middle section in this chart that I've found
BHP+materiality.PNG


Also, is there an easy way of giving the centre "hole" a label, too?

Cheers in advance
 
Wrap around, No
These are usually updated outside Excel eg: CorelDRAW, Photoshop etc

Centre, I'd just add a Text Box to the chart and link the Textbox to a cell

upload_2017-2-8_22-17-35.png
 
Hi Hui,
Thanks for this... yes, I'd thought of creating a text box (or perhaps Circle shape & adding text) for the middle...
What I'd hoped :rolleyes: was that I'd missed a click to allow me to get the labels for the segments to look like the "People, Environment, Society & Governance" labels in the image that I'd linked...
At the moment, I'm close, but no cigar...:(
upload_2017-2-8_15-26-16.png
 
Back
Top