Charting when using check boxes as data source

[Stinky Pete]

Morning,

The Non-conformance file we use as part of our Corporate GMP
Manufacturing complicance has a number of check boxes that users (7)
can select when determining what category a non-conformance falls
into. What I want to do is count and hence chart the values based on
the selected category type. BTW I cannot change the file and an
option group is not possible for the selections. I've managed to
create a crosstab that seems to be collating what I need, however I
really need to chart the types - Manangement think pretty charts work
better ;-) Anyeay, I've not been as yet been able to immedately find
what I need to do and was hoping for some guideance.

Regards,
Stinky Pete ;-)

[CDMAPoster]

On Jul 31, 7:33 pm, Stinky Pete <[e-mail]>
wrote:

Morning,

The Non-conformance file we use as part of our Corporate GMP
Manufacturing complicance has a number of check boxes that users (7)
can select when determining what category a non-conformance falls
into. What I want to do is count and hence chart the values based on
the selected category type. BTW I cannot change the file and an
option group is not possible for the selections. I've managed to
create a crosstab that seems to be collating what I need, however I
really need to chart the types - Manangement think pretty charts work
better ;-) Anyeay, I've not been as yet been able to immedately find
what I need to do and was hoping for some guideance.

Regards,
Stinky Pete ;-)

Use: 64 * [chk7] + 32 * [chk6] + 16 * [chk5] + 8 * [chk4] + 4 * [chk3]
+ 2 * [chk2] + [chk1] to choose the category from 128 possible values
in a table of categories. Some of the categories can be repeated for
multiple combinations. If the checkbox field values are -1 and 0, use
the Abs() function in conjuction with the calculation.

BTW, what are the names of your seven checkbox fields? I have to do
something very similar soon. Non-Conformance count (and frequency) is
one of the major metrics used in manufacturing processes to measure
quality improvement as per ISO recommendations.

James A. Fortune
CD********@FortuneJames.com