How to create an interactive doughnut chart in Microsoft Excel

https://youtu.be/VfDfgPdVR74
A doughnut chart is a type of circular chart that shows the relative proportions of different categories of data. It is similar to a pie chart, but it has a hole in the centre, which makes it look like a doughnut. A doughnut chart can be used to compare the parts of a whole, or to show the composition of multiple wholes. For example, a doughnut chart can show the market share of different products, or the revenue breakdown of different regions.

A doughnut chart is created by dividing a circle into segments that correspond to the values of each category. The size of each segment is proportional to the percentage of the total that it represents. The segments are usually arranged in descending order of magnitude, starting from the top. The hole in the centre of the doughnut chart can be used to display additional information, such as the total value, the title, or a legend.

A doughnut chart has some advantages and disadvantages compared to other types of charts. Some of the advantages are:

– It can show multiple levels of data by using concentric rings, which can help to reveal patterns and trends across categories.
– It can save space by using the hole in the centre for additional information, which can reduce clutter and improve readability.
– It can create a visual impact by using colours and shapes to highlight differences and similarities among categories.

Some of the disadvantages are:

– It can be difficult to compare the sizes of segments that are not adjacent or that have similar values, which can lead to inaccurate interpretations.
– It can be misleading if the segments are not labelled or if the values are not proportional to the angles, which can create confusion and ambiguity.
– It can be distracting if the colours and shapes are too flashy or inconsistent, which can reduce clarity and professionalism. How to create an interactive doughnut chart in Microsoft Excel. This Excel tutorial uses doughnut charts, secondary axis, XLOOKUP and Data Validation.
#excel #itseasytraining

Join this channel to get access to perks:
https://www.youtube.com/channel/UC1c7NBQ7tjBhPGegvCXid_A/join

If you want to support me, check this out: https://www.patreon.com/itseasy

Online training courses:

https://itseasytraining.teachable.com/
https://www.udemy.com/course/microsoft-excel-intermediate-course-z/?referralCode=365DF21869A9F9D2BFCB
Playlists for this channel:

Access: https://www.youtube.com/watch?v=WyFj2eeMfSI&list=PLK99llucAWls71sYcwuXUGuTB33Iz4sFP&ab_channel=ITsEasyTraining1st

Excel: https://www.youtube.com/watch?v=yKobsDbGbyM&list=PLK99llucAWlt5BjHVQwlzFWcqtOR0xMsc&ab_channel=ITsEasyTraining1st

Word: https://www.youtube.com/watch?v=1yB2yP_5LQ0&list=PLK99llucAWlvAvYnQHbuqPzahwXC2GP5T&ab_channel=ITsEasyTraining1st

Visio: https://www.youtube.com/watch?v=ucHD0C4xeBY&list=PLK99llucAWlubxRVLca37R6Jh4jSZyxC3&ab_channel=ITsEasyTraining1st

Project: https://www.youtube.com/watch?v=5Fmgei_PagI&list=PLK99llucAWltWM3-Ohg_V1d6Q0STPAzG7&ab_channel=ITsEasyTraining1st

PowerPoint: https://www.youtube.com/watch?v=fOhiNLAzVAQ&list=PLK99llucAWluWCI4_xLnfbjm5GpAZo9Ye&ab_channel=ITsEasyTraining1st

Publisher: https://www.youtube.com/watch?v=I1-DPJTSvg4&list=PLK99llucAWlvCyOwrQh-OSlPpXWBIEVYq&ab_channel=ITsEasyTraining1st

OneNote: https://www.youtube.com/watch?v=JS5Y_BSEbgg&list=PLK99llucAWlteO7uOpQHz5rOBCdnZ0YMD&ab_channel=ITsEasyTraining1st

Office 365: https://www.youtube.com/watch?v=fphQ0jmv0-8&list=PLK99llucAWlv0L0K0wsLW_S5VkOHFuxli&ab_channel=ITsEasyTraining1st

#itseasytraining

Classroom based courses can be arranged at https://www.itseasy.co.uk/

Courses are available through Microsoft Teams, Online and Face to face in the UK

Online courses at https://itseasytraining.teachable.com/

Udemy Courses https://www.udemy.com/user/stephen-saxton/

Training Guide Books

Excel for New Managers

Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Project-Overview-need-about/dp/1705474632

Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Visio-Basics-Stephen-Saxton/dp/B089CSJBMD

Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv

---