469,943 Members | 2,591 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,943 developers. It's quick & easy.

Charting when using check boxes as data source

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 ;-)

Jul 31 '07 #1
1 1388
On Jul 31, 7:33 pm, Stinky Pete <Peter.Mor...@symbionhealth.com>
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

Aug 1 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jerry Sievers | last post: by
reply views Thread by Matt. | last post: by
10 posts views Thread by A.M | last post: by
3 posts views Thread by Igor | last post: by
20 posts views Thread by Joe | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.