• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

How to create a donut chart

Hello, I need to create a donut chart from three values:

QTYMDR = sum of records in a date range search
OpenMDR = sum of records in a date range search which are in an open status
ClosedMDR = sum of records in a date range search which are in a closed status

I create a new chart with the chart wizard and then select my three values. I select donut and click next. The sum of qtymdr is at the bottom of the next screen and I then select and drop the openMDR and closedMDR into the available series text box. When I continue the report loads but it does not appear to work.

I want the QTYMDR value in the center, then OpenMDR and ClosedMDR in the outer ring.


Donut example
0
gogetsome
Asked:
gogetsome
1 Solution
 
mlmccCommented:
What reporting tool are you using?

mlmcc
0
 
gogetsomeAuthor Commented:
The one in access 2003.
0
 
Nico BontenbalCommented:
You need to get the data in different columns. Every column has a ring in the donut. Like this:
Sample
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now