Hey all ... Windows 2K, Excel 2K

I am attempting to write some code that will select the relevant data for
each day of the month and create a line chart using the data.

The entire month's data is set out in a single spreadsheet. This
information is downloaded from an outside source so this is my starting
point.

The data is set out as follows:

Column A Column B Column C Column D
Jan 1/06 00:30 5 6
Jan 1/06 01:00 4 9
Jan 1/06 01:30 2 5 (and so
on for the entire day until 23:30)
Jan 2/06 00:30 6 4
Jan 2/06 0:100 7 3 (and so
on for the entire day until 23:30)

That data continues for every day in the month in the same manner as set out
above.

I want to chart the data in Columns B through D by day.

I am not having difficulties creating the charts, but automating the
creation of the charts. I am uncertain as to how to write the code to loop
through each day.

If I have not sufficiently explained the situation, please do not hesitate
to ask for clarification.

TIA for any assistance!

Debra

I meant that I wanted to create a chart by day, not by month as the original
subject suggested. The data is provided to me on a monthly basis but by day
in the format set out originally.

Thanks
"Debra Farnham" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hey all ... Windows 2K, Excel 2K
>
> I am attempting to write some code that will select the relevant data for
> each day of the month and create a line chart using the data.
>
> The entire month's data is set out in a single spreadsheet. This
> information is downloaded from an outside source so this is my starting
> point.
>
> The data is set out as follows:
>
> Column A Column B Column C Column D
> Jan 1/06 00:30 5 6
> Jan 1/06 01:00 4 9
> Jan 1/06 01:30 2 5 (and
> so on for the entire day until 23:30)
> Jan 2/06 00:30 6 4
> Jan 2/06 0:100 7 3 (and so
> on for the entire day until 23:30)
>
> That data continues for every day in the month in the same manner as set
> out above.
>
> I want to chart the data in Columns B through D by day.
>
> I am not having difficulties creating the charts, but automating the
> creation of the charts. I am uncertain as to how to write the code to
> loop through each day.
>
> If I have not sufficiently explained the situation, please do not hesitate
> to ask for clarification.
>
> TIA for any assistance!
>
> Debra
>