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!
Last edited by TomBP; 02-19-2011 at 09:46 AM.
Should the table have 2 fields and 2 rows
|Color|Value|
|Green|60|
|Red|40|
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.
See attached. Is that not what you wanted?
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.
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];
If you add a blank field to your automation table and report all 3 fields the chart will be as you want.
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.
Last edited by TomBP; 02-18-2011 at 01:47 PM.
Apparently my data series were not formatted the correct way. They should be in rows instead of columns.
Thanks for your help Andy. Case solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks