• 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.

Multiple-element doughnut chart with rounded edges

Niko_P

New Member
Hi guys! I have a challenge for you today. I am wondering if there is a way to create a chart like this one in excel:

74369

Now, I am familiar with how one can achieve a single-element doughnut chart using scatter-plot combination but it is not what I am looking for. I have given this a few tries myself but had no success with accomodating multiple elements. Also, disregard the lines, the focus here is on the shape of the doughnut parts(elements).

Looking forward to your suggestions! :)

1620139616043.png
 

vletm

Excel Ninja
Niko_P
Answer is yes
... eg something like below
Screenshot 2021-05-04 at 18.50.47.png
Without Your sample Excel-file,
which has Your sample data
that would possible to need to do some modifications .. or not?
 

Niko_P

New Member
Niko_P
Answer is yes
... eg something like below
View attachment 74370
Without Your sample Excel-file,
which has Your sample data
that would possible to need to do some modifications .. or not?
Hi vletm, thanks so much for getting back to me on this!

Very cool! this is scatter and points make up the chart? :O

I dont have a source file, I was just hoping to be able to make these charts for 3 simple KPI's. Is it also possible to smooth out the edges, i see they are kind of fuzzy? Or is this just a zoom issue maybe and it looks good on your screen at 100% zoom?

Anyways, if you would share your secret, I would really appreciate it :)

Regards,
Nikolai
 

vletm

Excel Ninja
Niko_P
It's a scatter chart with only line.
How would You make something without even sample data?
How do You count until three based that Your sent snapshot? ... maybe that's Your simple - who knows?
I tested with one settings - that's why looks as it looks - settings matters!
What is someones secret? ... You asked a scatter chart or what?
As I wrote - without even a sample file - You would have new ... challenges.
Here, my basic sample file.
Ha en fin kveld.
 

Attachments

Niko_P

New Member
Niko_P
It's a scatter chart with only line.
How would You make something without even sample data?
How do You count until three based that Your sent snapshot? ... maybe that's Your simple - who knows?
I tested with one settings - that's why looks as it looks - settings matters!
What is someones secret? ... You asked a scatter chart or what?
As I wrote - without even a sample file - You would have new ... challenges.
Here, my basic sample file.
Ha en fin kveld.
vletm, thank you again for your swift reply!

There isn't sample data because I am looking to make a reusable template (which will be used by somebody else with different data every quarter). Very simple data is expected though, I have included a sample file this time around. Please see attached.

Thanks for sharing the file, very interesting solution. By setting lines in your file to "smooth" I was able to correct for fuzzyness, looks perfect now.

74379

I appreciate the swift responses and your geometrical solution to my problem. Please share any further insights you might have but I believe I can make it work using your methodology.

Again, very impressive!

Med vennlig hilsen,
Nikolai
 

Attachments

vletm

Excel Ninja
Niko_P
... that 'smooth' is one way ... I would modify steps too.
Your sent files charts looks other than that which You've asked ...
... of course, those are possible to do as I've done with my sample.
But if You would have sent that file at once
,,, as You wrote I can make it work
I could have made it work already my way.
Lykke til og suksess på din valgte vei
 
Top