J
John Oliver
I have a spreadsheet that has a number of values entered each day. I
would like to create a bar chart that will take the values for the
corresponding day for the past month or so and graph the average. So,
there would be seven of these charts. Each has a 0-1AM, 1-2AM, and so
on. The value for each of those time periods will be the average of the
values for that day of the week over the past month. Mondays chart
would have the past 4 Mondays, etc. Each time a new day is added to the
spreadsheet, the chart for that day of the week should "jump" forward,
and use that days data while dropping the oldest day.
Is that confusing enough?
would like to create a bar chart that will take the values for the
corresponding day for the past month or so and graph the average. So,
there would be seven of these charts. Each has a 0-1AM, 1-2AM, and so
on. The value for each of those time periods will be the average of the
values for that day of the week over the past month. Mondays chart
would have the past 4 Mondays, etc. Each time a new day is added to the
spreadsheet, the chart for that day of the week should "jump" forward,
and use that days data while dropping the oldest day.
Is that confusing enough?