Hi everyone,

I need to make a Line chart that shows the amount of "bad" websites per week
for the past 8 weeks from the following example. Please keep in mind that
the following is just a subset of the actual data for demo, the real data
goes on for a thousand or so rows.

Example:

Name Date URL
Chris 6/16/06 17:13 http://www.myspace.com <red
Chris 6/15/06 15:13 http://www.myspace.com <red
Chris 6/10/06 12:13 http://www.google.com
Chris 6/8/06 16:58 http://www.cpearson.com
Chris 6/5/06 11:04 http://www.hotornot.com <green
Chris 5/17/06 16:58 http://www.cpearson.com
Chris 5/16/06 16:58 http://office.microsoft.com
Chris 5/12/06 16:58 http://www.motobit.com
Chris 5/11/06 16:58 http://www.bored.com <yellow
Chris 4/27/06 16:58 http://www.google.com
Chris 4/26/06 16:36 http://www.google.com


The EntireRow.Interior.ColorIndex property is set to the above color, next
to the URL if the URL matches specific keywords. Additionally, the Date
column is sorted and is formatted via .NumberFormat = "m/d/yy h:mm;@" so
Excel recognizes the dates.

I have two variables BadSiteCounter and GoodSiteCounter which I use to
calculate the overall percentage of "bad" websites. I don't know whether
these counters will be of any use to create this chart, but they are there.

I am absolutely clueless as how to tackle this. When I hightlight each row
containing a "bad" website should I enter a 1 in the cell to the right of
the URL? Will that help with creating the chart?

Thanks in advance,

Chris