Hi, I'm trying to create the following chart in excel. Is there anyone that can help me with this?
chart.jpg
Hi, I'm trying to create the following chart in excel. Is there anyone that can help me with this?
chart.jpg
Last edited by Reinder; 12-11-2020 at 03:31 AM.
Not a useful response, but I have to congratulate you for the best post title I've seen here this year.
The site should have an award for that. I'd nominate yours.
That said, I very much doubt Excel could do this. I figure you'd need to use specialized software for something like this.
Looks more like something you might get out of mind-mapping software, though I haven't seen anything like it.
You might be better off just Googling: nested doughnut chart. There's a lot of interesting threads, just not sure what would be most useful to you.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Perhaps I am just more optimistic than hrlngrv, but I think Excel can do this. That doesn't mean that Excel is the best or even a good choice for this, just that I think it could be possible with enough time, effort, and ingenuity.
What I see is something very similar to this "windrose" project I helped someone with. Basically, it is a filled radar chart with a lot of work to get the various "stacked radar" series to look right: https://www.excelforum.com/excel-cha...wind-rose.html
Another, simpler one: https://www.excelforum.com/excel-cha...ttachment.html
Finally, this example: https://www.excelforum.com/excel-cha...ial-chart.html This one might be particularly interesting in the "extra category bug" that seems to be part of filled radar + radar combination charts. You might need such a combination chart to get the unevenly spaced gridlines that your picture shows.
Basically, I think if we spend enough time and effort understanding how a filled radar chart works, we can build this. Whether it is worth the effort or easier to find a third party charting application that knows how to do this out of the box is a different question.
Originally Posted by shg
Please explain how, in Excel, one could put curved text into the outermost ring in the chart?
The text boxes and lines from those to the outermost ring are NBD since they'd need to be done manually.
Tx all, seems to be a sunburst chart (not a nested doughnut ). But that still gives a lot of challanges. Perhaps I just need to use Powerpoint to manually create it or something...seems a hell of a lot of work to recreate. However, if I figure out how to create it in the meantime, I will make sure to post it here...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks