These 5 weights - are they 5 fields on the patient's record, or are they recorded in a related table, so there are 5 (maybe more, maybe less) records of weights for the patient?
Your x-axis can chart values from one field from a set of records--five records, 6 records-20 records however many you pull up in a found set. But only if you have one record for each found set.
the weights are 5 separtate fields (weight baseline, weight follow up visit 1, etc). The visits are dates - baseline visit, follow up 1 visit and each a separate field too.
I want the chart to have the dates along the bottom with the stacks above representing the weights on each visit. Seems like a pretty straightforward thing, but I can't figure it out...any input is appreciated!