Pie Chart Problem

[Tony Montana]

I have a form into which I enter data. The first 2 boxes are names and the
third is a date. These are no problem. I then have 5 categories which have 3
check boxes each depending on what is decided, say Red, Amber or Green.
Example:
Red Amber Green
Health & Safety
Delivery

I want to create a pie chart from the information so that I can see on a
particular day, what percentage was Red, what percentage was Amber and Green
and so on for each category. I would therefore have 5 charts all together. I
am not that skilled with access so am struggling to create the report. Any
help woud be most appreciated as I am losing my grip on reality now.

 

[Duane Hookom]

It's difficult to picture your data. If you have 5 fields of categories, then
I think this needs to be normalized.

Charts have Link Master/Child properties that can filter a chart to a value
in the report's record source.