Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
automatically updating graphs based upon conditional variables
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
automatically updating graphs based upon conditional variables
"GGC" wrote in message
... 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? 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. -- David Biddulph |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
automatically updating graphs based upon conditional variables
Thank you. Will give it a try.
G "David Biddulph" wrote: "GGC" wrote in message ... 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? 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. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting based on column | Excel Discussion (Misc queries) | |||
conditional formula - based on 2 separate criteria | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
sum automatically from last 12 months based on current date | Excel Worksheet Functions | |||
How do I do conditional format based on a cell with a formula? | Excel Worksheet Functions |