November 26, 2020
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 attached
November 26, 2020
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.
November 26, 2020
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.
July 16, 2010
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
November 26, 2020
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.
June 25, 2020
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
1 Guest(s)