Dwade -

Others may reply with help for your specific questions, but I have several
very general suggestions: Arrange your data in standard list (database) form
as you have, but place all data on a single sheet. Use Excel dates (after
solving the problem that "Excel always fouls up the time"). Use a pivot
table to summarize the data, especially the Group feature for Excel dates.
If necessary, use helper columns in your database (e.g., for the "any
multiple of months" feature you mentioned). Create automatically-generated
pivot charts.

- Mike

http://www.MikeMiddleton.com



"Dwade" wrote in message
...
I have Blood Pressure Monitoring series. where

A = Day of Week Month Year as Wednesday Apr 1-09-9:30am this is a text
value
not a date as Excel always fouls up the time. Days of the month are 1 - 31
or
1 - 30 or 1-28/29

B= Diastolic Pressure as Number no decimal places

C= Systolic Pressure as Number no decimal places

D= Pulse rate as number no decimal places

I can create a chart for each month. With each month or single for each
month on separate sheet. Each month is formated and arranged the same.

How do I set the chart data range for all months or any multiple of months
14, 2, 3 or 4 or any number of work sheets on separate work sheets, as 1
chart?