Errors with per Week Chart
 

Hello, the sheet I'm working on records the number of seizures per day
of a specific patient. I then have a sperate column which has the sum
of the seizures in a given week. Obviously, these sums appear every
seven cells. Adjacent to these cells is the date of the given week. So,
for example, the total amount of seizures in the week of 12/18/05 is 18.
Unfortunately, to protect the patient's privacy, I cannot provide a
download to the actual document.

Now, I'd like to graph the amount of seizures per week. When I try to
do this, I either get a bunch of different series and no apparent way
to have the date on the x-axis, or I get one series but I get an error
telling me I've exceeded the maximum number of data points, and only
two or three dates show up along the x-axis. What am I doing wrong?
Thanks in advance.


--
JohnA
------------------------------------------------------------------------
JohnA's Profile: http://www.excelforum.com/member.php...o&userid=36245
View this thread: http://www.excelforum.com/showthread...hreadid=560199