How do you get the 2020-2022 outer ring data to match up with the inner ring data? I.e. how did the outer ring for 2022 know to use three data points for the inner ring versus the 2020 and 2021 only having two data points? Thank you very much for the video!
That’s a great question. It has to do with the order and the totals. Make sure that the order of each set of years is the same in both data sets. Then make sure that the total for one year is the same as the total for the individual items for that same year. So, for example, the total for 2021 must add up to the total of each of the products that was launched in 2021. If you do this and the dates are in the same order then it just automatically happens. It also makes logical sense. If you’re plotting everything that was launched in 2021 you’ll have a total for 2021 but also totals for the individual items that launched in that year, and the two should be exactly the same. I hope this helps. Feel free to ask more questions if you get stuck.
Brilliant! Wanted to do a chart like this for ages but never knew how to get it done in excel. Great Video, clear and concise instructions, no unnecessary frills, straight to the point. Love it!
OMG that is so wonderful to hear. I hope that your thesis goes well for you. Best of luck! And thank you so much for letting me know that it was helpful to you.
That’s a great question. It has to do with the order and the totals. Make sure that the order of each set of years is the same in both data sets. Then make sure that the total for one year is the same as the total for the individual items for that same year. So, for example, the total for 2021 must add up to the total of each of the products that was launched in 2021. If you do this and the dates are in the same order then it just automatically happens. It also makes logical sense. If you’re plotting everything that was launched in 2021 you’ll have a total for 2021 but also totals for the individual items that launched in that year, and the two should be exactly the same. I hope this helps. Feel free to ask more questions if you get stuck.
This is a really neat visual; thanks for the tutorial! Just a curiosity question, is there a reason you start as a donut and not a pie chart? One of the first things you do at 1:16 is essentially turn it into a pie chart. I’m guessing you don’t have the overlay option with a pie chart? Just curious, thanks!
Great question, yes there is a reason to use a donut chart. A pie chart can't be 'stacked on itself' where as a donut chart can so you can't achieve this same effect with a donut chart.
Hi, I tried to replicate this. It is so cool! But when it comes to the step to format labels of the 2nd serie the "value from cells" option does not show up. Is there any workaround?
Thank you so much for letting me know. Finding more information about this for you was on my To Do List for Monday. I am so glad you found the solution.
I have been trying to work with a pie chart for ages and I still can't seem to get it to work. I want to summarize the same question, same answer options but different amount of answers for each one, into one single pie chart? From three sheets. I know how to make a pie chart and get the percentages for one sheet, however I can't seem to summarize any more sheets into the pie chart. I have tried using select data, and it works if I use bar charts but that doesn't give me the percentages into one single bar. How do you get three different sheets of data, same questions but different amount of answers, into one single pie chart? Thank you.
I’m not 100% understanding exactly what you’re asking for. But my first thought is that you should assemble all of your data into a single sheet and then plot the pie chart from there. Does this sound doable for you?
Not a problem at all. I just want you to be able to achieve what you’re trying to do. So I would bring all the data, by way of links, into a separate worksheet, and then do your pie chart from there. Just make sure to link to the original data, by referencing the cell rather than bringing across the actual fixed numbers. That will mean that if your other worksheets change, then your pie chart should change accordingly. Keep me in the loop. If you need more help, and I’ll try and point you in the right direction. Best of luck!
How do you get the 2020-2022 outer ring data to match up with the inner ring data? I.e. how did the outer ring for 2022 know to use three data points for the inner ring versus the 2020 and 2021 only having two data points? Thank you very much for the video!
That’s a great question. It has to do with the order and the totals. Make sure that the order of each set of years is the same in both data sets. Then make sure that the total for one year is the same as the total for the individual items for that same year. So, for example, the total for 2021 must add up to the total of each of the products that was launched in 2021. If you do this and the dates are in the same order then it just automatically happens. It also makes logical sense. If you’re plotting everything that was launched in 2021 you’ll have a total for 2021 but also totals for the individual items that launched in that year, and the two should be exactly the same. I hope this helps. Feel free to ask more questions if you get stuck.
Brilliant! Wanted to do a chart like this for ages but never knew how to get it done in excel. Great Video, clear and concise instructions, no unnecessary frills, straight to the point. Love it!
I’m so happy you enjoyed this video.
Love this video! I spruced up my presentation and had everyone asking how to do it. New subscriber here!
Thanks for the sub! I'm so glad you got to impress everyone too - that makes me smile.
I love how clearly you speak
Nice video too
So nice of you to say that 😊
What a useful video! Great explaining step by step
Glad you liked it
thanks to you I even used this type of charts in my bachelor thesis!
OMG that is so wonderful to hear. I hope that your thesis goes well for you. Best of luck! And thank you so much for letting me know that it was helpful to you.
great video, very easy to follow - thank you!
You are welcome!
2:55 your data lined up perfectly on the outside with the inside by category. Mine does not. How did you manage that?
That’s a great question. It has to do with the order and the totals. Make sure that the order of each set of years is the same in both data sets. Then make sure that the total for one year is the same as the total for the individual items for that same year. So, for example, the total for 2021 must add up to the total of each of the products that was launched in 2021. If you do this and the dates are in the same order then it just automatically happens. It also makes logical sense. If you’re plotting everything that was launched in 2021 you’ll have a total for 2021 but also totals for the individual items that launched in that year, and the two should be exactly the same. I hope this helps. Feel free to ask more questions if you get stuck.
Nice and clear video, Thank you
Glad it was helpful!
Hi, this video has been super useful. I just have a format question, is it possible to reduce the width of the outer layer of the chart?
Unfortunately not. I had a look for you and there is no way to adjust the width of the outer layer. Sorry about that.
Thanks for checking 😊
My pleasure.
Thank you very much!
You're welcome!
This is a really neat visual; thanks for the tutorial! Just a curiosity question, is there a reason you start as a donut and not a pie chart? One of the first things you do at 1:16 is essentially turn it into a pie chart. I’m guessing you don’t have the overlay option with a pie chart? Just curious, thanks!
Great question, yes there is a reason to use a donut chart. A pie chart can't be 'stacked on itself' where as a donut chart can so you can't achieve this same effect with a donut chart.
Hi, I tried to replicate this. It is so cool! But when it comes to the step to format labels of the 2nd serie the "value from cells" option does not show up. Is there any workaround?
Sorry, resolved, I had a old version of Excel. Thanks for the video.
Thank you so much for letting me know. Finding more information about this for you was on my To Do List for Monday. I am so glad you found the solution.
Thanks a lot. It is very very informative and useful yo me as it is completely unknown to me.
Glad to hear that
I have been trying to work with a pie chart for ages and I still can't seem to get it to work. I want to summarize the same question, same answer options but different amount of answers for each one, into one single pie chart? From three sheets. I know how to make a pie chart and get the percentages for one sheet, however I can't seem to summarize any more sheets into the pie chart. I have tried using select data, and it works if I use bar charts but that doesn't give me the percentages into one single bar.
How do you get three different sheets of data, same questions but different amount of answers, into one single pie chart? Thank you.
I’m not 100% understanding exactly what you’re asking for. But my first thought is that you should assemble all of your data into a single sheet and then plot the pie chart from there. Does this sound doable for you?
@@MasterMicrosoftOffice It does! thank you, I was quite frustrated while writing my comment, so I apologize if it was difficult to understand.
Not a problem at all. I just want you to be able to achieve what you’re trying to do. So I would bring all the data, by way of links, into a separate worksheet, and then do your pie chart from there. Just make sure to link to the original data, by referencing the cell rather than bringing across the actual fixed numbers. That will mean that if your other worksheets change, then your pie chart should change accordingly. Keep me in the loop. If you need more help, and I’ll try and point you in the right direction. Best of luck!