• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Doughnut Chart from Excel|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Doughnut Chart from Excel|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumGeneral Excel Questions & Answe…Doughnut Chart from Excel
sp_PrintTopic sp_TopicIcon
Doughnut Chart from Excel
Avatar
Lakshmipathi Ganesan
Member
Members
Level 0
Forum Posts: 18
Member Since:
November 26, 2020
sp_UserOfflineSmall Offline
1
November 30, 2020 - 6:38 pm
sp_Permalink sp_Print

I am trying to prepare Doughnut chart for Tickets Created and Closed for a month / quarter / year.

My understanding is Doughnut chart should always be in percent in which case, can you please help me to understand how to arrive this? I mean, how to arrive the percent for open tickets and closed tickets per module ? Sample data attachedDoughnut.jpgImage Enlarger

sp_PlupAttachments Attachments
  • sp_PlupImage Doughnut.jpg (7 KB)
Avatar
jab che
Member
Members
Level 0
Forum Posts: 16
Member Since:
June 25, 2020
sp_UserOfflineSmall Offline
2
November 30, 2020 - 7:48 pm
sp_Permalink sp_Print sp_EditHistory

Hi Lakshmipathi,

After you've added a standard Doughnut chart (via the Insert, Charts part of the Ribbon), you need to add Data Labels and select the appropriate formatting options
Hopefully, it will eventually look something like the attached example

jim

Avatar
Lakshmipathi Ganesan
Member
Members
Level 0
Forum Posts: 18
Member Since:
November 26, 2020
sp_UserOfflineSmall Offline
3
November 30, 2020 - 8:59 pm
sp_Permalink sp_Print

Thank you very much for pitching in and help.  My doubt is how do I arrive the Created percent automatically when I have the data only as ticket counts ?  To cite an example, for FI, created ticket count shows as 75 and from there, your chart shows 34%.  I want to know, from where I can fetch this percent.  Hope, my query is clear now.

Avatar
Lakshmipathi Ganesan
Member
Members
Level 0
Forum Posts: 18
Member Since:
November 26, 2020
sp_UserOfflineSmall Offline
4
November 30, 2020 - 9:11 pm
sp_Permalink sp_Print

I myself got the direction and once again thank you very much for the help.

Avatar
Lakshmipathi Ganesan
Member
Members
Level 0
Forum Posts: 18
Member Since:
November 26, 2020
sp_UserOfflineSmall Offline
5
November 30, 2020 - 9:18 pm
sp_Permalink sp_Print

Not sure whether I can continue with the same thread but wanted to know how to make it as a Dash Board.  My requirement is to module wise / year wise Doughnut Dash Board

Avatar
Lakshmipathi Ganesan
Member
Members
Level 0
Forum Posts: 18
Member Since:
November 26, 2020
sp_UserOfflineSmall Offline
6
December 1, 2020 - 1:23 am
sp_Permalink sp_Print

I would be much obliged if someone can help me preparing Doughnut Dash Board for the attached data.  In the next couple of days, I need to present it to all my clients.

Avatar
jab che
Member
Members
Level 0
Forum Posts: 16
Member Since:
June 25, 2020
sp_UserOfflineSmall Offline
7
December 1, 2020 - 10:26 am
sp_Permalink sp_Print

You have the tools, use them wisely to complete the job

If you need any advice on a particular issue, I am happy to help with that, but I cannot second guess your requirements and do this for you

Avatar
Lakshmipathi Ganesan
Member
Members
Level 0
Forum Posts: 18
Member Since:
November 26, 2020
sp_UserOfflineSmall Offline
8
December 1, 2020 - 3:43 pm
sp_Permalink sp_Print

Thanks for the response.  Yes I know the tools are available but since I am not familiar with Dash Boards, I sought the help here.  I have explained my requirement that I need to prepare a Doughnut chart in DashBoard format for the Tickets Created versus Closed which could be month wise or customer wise.  I know how to prepare a Doughnut chart but not sure for this specific requirement.  Hope someone here can guide me.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4450
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
9
December 1, 2020 - 7:58 pm
sp_Permalink sp_Print

Hi Lakshmipathi,

The purpose of the forum is to help you with specific Excel questions and troubleshooting. 'How to build a dashboard' is too broad and therefore verges on Excel consulting, rather than troubleshooting. In other words, helping you build a dashboard is outside the scope of forum support.

If you'd like to learn how to build dashboards, please consider my Excel Dashboard course.

Mynda

Avatar
Lakshmipathi Ganesan
Member
Members
Level 0
Forum Posts: 18
Member Since:
November 26, 2020
sp_UserOfflineSmall Offline
10
December 1, 2020 - 8:06 pm
sp_Permalink sp_Print

I wish to reiterate that I am not asking to send me a step by step document but requesting to let me know whether it is possible to prepare Doughnut DashBoard for the tickets created versus closed for a month or for a customer.  From the tutorial I went through, my understanding is I need to have two Doughnut charts - one for month wise / customer wise created and another for closed.  Can you please let me know my understanding is correct or not.

Avatar
jab che
Member
Members
Level 0
Forum Posts: 16
Member Since:
June 25, 2020
sp_UserOfflineSmall Offline
11
December 1, 2020 - 10:35 pm
sp_Permalink sp_Print

There are many ways to present the same information visually, some are better than others
The best way to find out (and improve your Excel expertise) is to experiment, asking for technical help with specific issues as they arise
There are no right or wrong solutions and only you and those around you will know what is better for your needs

It does take time, but the final results (in both your knowledge and your dashboard) will be the better for it

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 205
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
stuart burge
Bruce Tang Nian
Scot C
Othman AL MUTAIRI
Misael Gutierrez Sr.
Attif Ihsan
Kieran Fee
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Forum Stats:
Groups: 3
Forums: 24
Topics: 6223
Posts: 27295

 

Member Stats:
Guest Posters: 49
Members: 31920
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.