chart - calculate the number of months

Hi. I just registered! I'm not sure if I have this thread in the right forum, but here I go with my question.

I have a spreadsheet of data for patients. I have their first visit and their last visit (so two visit per patient). I have the DATE column and other data columns. What I want to do (and don't even know if it's possible) is to create a chart representing the changes in the patients condition from first visit to the last visit. One axis (the Y-axis) will have values of the patient results and X-axis would have [b]the number of months since their last visit.

SO, every patient is represented by a line with two end points. ALL lines will begin on 0 (zero) for the X-axis because the zero represents the first visit. And the last end point of the line would represent the patients last visit.

The chart would have multiple lines NOT connected.

Is this possible in Excell? OR would I just have to calculate the number of months since the first visit by hand?

For ex. If I had a visit in 12/01/2001 and then lthe ast one in 5/10/2006, it would be 53 months since my last visit.

Thanks for any help.

The calculating of number of months could be done with this formula:

Please Login or Register  to view this content.

This is for date of first visit in A1 and date of last visit in B2. It is possible that the result you get is formated as a date. Select Format - Cells - Number to display it is as number of months.

To round of to the nearest whole number of months use the ROUND(formula) on the result.

Please Login or Register  to view this content.

About your problem with displaying your data in a chart, I think it would be possible to do with som convertion and manipulation of your data, but would need some more info to give an answer. I'm not sure I understand what you want your chart to look like.