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
gogetsomeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Nico BontenbalConnect With a Mentor Commented:
You need to get the data in different columns. Every column has a ring in the donut. Like this:
Sample
0
 
mlmccCommented:
What reporting tool are you using?

mlmcc
0
 
gogetsomeAuthor Commented:
The one in access 2003.
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.

All Courses

From novice to tech pro — start learning today.