Doughnut chart

**TomBP** · 02-16-2011, 05:39 AM

Hi,

I want to implement doughnut charts in my form. This chart needs to display two values.

Can someone help me achieve the same chart in Access as displayed in Excel (see jpg)? I've also added a sample database with the records already set-up.

Thanks in advance!

**Andy Pope** · 02-16-2011, 08:23 AM

Should the table have 2 fields and 2 rows

|Color|Value|
|Green|60|
|Red|40|

**TomBP** · 02-16-2011, 10:13 AM

I'm not exactly sure what you're aiming at here.

The colors green and red should not be part of the chart itself. They are just a header name.

**Andy Pope** · 02-16-2011, 10:21 AM

See attached. Is that not what you wanted?

**TomBP** · 02-16-2011, 10:56 AM

That's not exactly what I'm looking for.

Form2 does not depend on a table. The goal is to have the chart recalculated according to the numbers in the table.

Furthermore, the data in the table needs to be inputted as shown in table Automation.

**Andy Pope** · 02-16-2011, 11:05 AM

I no expert in Access can't help any further.

FYI Form2 IS based on the contents of Table1.
Here is the select query the chart uses.

SELECT Table1.[Color], Sum(Table1.[Value]) AS SumOfValue FROM Table1 GROUP BY Table1.[Color];

**Andy Pope** · 02-17-2011, 06:45 AM

If you add a blank field to your automation table and report all 3 fields the chart will be as you want.

**TomBP** · 02-18-2011, 07:12 AM

Andy,

I have absolutely no idea how you did it, but it works.

Did you create the graph using the chart wizard or the properties? I can't seem to recreate what you did.