You've received some good suggestions, any of which will give you what
you want -- though John, IMO, went a little overboard. {g}
Yet another option to consider is a stacked column chart. Add a column
for systolic less the diastolic as in
date time sys dia diff
11/2/2005 10:00 130 74 56
18:00 127 60 67
12/2/2005 10:00 135 75 60
13/02/2005 10:00 140 80 60
19:00 135 75 60
Now, plot date and time on the x-axis and dia and diff on the y-axis as
a stacked column.
Yet another alternative has the added benefit that it doesn't require
you to massage the data as above (i.e., deleting the duplicate date
values). Leave the data in the original format, i.e.,
date time sys dia diff
11/2/2005 10:00 130 74 56
11/2/2005 18:00 127 60 67
12/2/2005 10:00 135 75 60
13/02/2005 10:00 140 80 60
13/02/2005 19:00 135 75 60
Now, create a Pivottable and Pivotchart (from the Data menu). Put the
date and time as row fields, the dia and diff as data fields. You'll
see a 'Data' item in the top row of the table. The 'Sum of Dia' and
'Sum of diff' will be one below the other. Click and drag that to the
right until it overlaps the Totals column and let go of the mouse. Now
the 2 fields will be in adjacent columns. Finally, change the type of
the associated chart to 'Stacked Column.'
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions