automatically updating graphs based upon conditional variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have patients that have two variables assigned to them based upon results
of testing.
The variables are numbers between 1-6 and there are always 2 numbers
assigned to each patient.
We need to set up a histogram chart that automatically updates each time a
new patient is added to the database.
The histogram should reflect the addition of the new patient, and adjust the
graph to reflect the HIGHER of the two numbers assigned to the patient.
Example:
Patient A: 4, 3
Patient A is thus a "4"
one new "4" patient is added to the histgram to represent this patient.

Anyone know how to do this?
 
GGC said:
We have patients that have two variables assigned to them based upon
results
of testing.
The variables are numbers between 1-6 and there are always 2 numbers
assigned to each patient.
We need to set up a histogram chart that automatically updates each time a
new patient is added to the database.
The histogram should reflect the addition of the new patient, and adjust
the
graph to reflect the HIGHER of the two numbers assigned to the patient.
Example:
Patient A: 4, 3
Patient A is thus a "4"
one new "4" patient is added to the histgram to represent this patient.

Anyone know how to do this?
Click to expand...

If you create a column for the maximum of the two numbers for that patient
=MAX(C2,D2) if the numbers are in columns C & D.

Then if that column is E, use =COUNTIF(E:E,G2) where G2 is 1, & copy down
for values 1 to 6 in column G, you can then produce your histogram from
those values.
 
Thank you. Will give it a try.
G

David Biddulph said:
If you create a column for the maximum of the two numbers for that patient
=MAX(C2,D2) if the numbers are in columns C & D.

Then if that column is E, use =COUNTIF(E:E,G2) where G2 is 1, & copy down
for values 1 to 6 in column G, you can then produce your histogram from
those values.
Click to expand...
 
Back
Top