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?

[Webinar] Streamline your web hosting managementRegister Today

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
All Courses

From novice to tech pro — start learning today.