Chart by Date (Monthly)

  • Thread starter Thread starter Debra Farnham
  • Start date Start date
D

Debra Farnham

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
 
Back
Top