Complex chart Question

A

Air-ron

I have an idea for a fairly complex chart, but no idea how to implement it:

I have customer count data at 2 hour intervals, 24 hours a day, 7 days a
week. I would like to chart a line graph, using separate lines (series) for
each day of the week(sun through sat), and the x-axis would be the time, from
12:00 AM to 10:00 PM.

The hard part is this, I would like the lines to be the average count for
the month preceeding the most recent week, and also have the data point for
the most recent week somehow connected to the line for the averages. (I
guess it would be similar to what a stock chart looks like)

So, in other words, there would be 7 lines on the chart, and at each time
interval, there would be a small line extending either up or down to show how
the most recent week's data compares to the average for the previous month.

I imagine I'll use separate queries to total the previous month, and the
recent week, and then a third query to combine them to one that has the 12
time intervals for each of the 7 days. Then what???

(I am using Access 2000)
aaron
 
Top