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.