charting more than one worksheet

[Kelli]

I have data in one worksheet(February) and data in another worksheet (March). I need to chart averages over a five day period (Feb 28,29, March 1, 2, 3). I will need to do this everyday. I can not seem to find an easy way to do this. Can anyone help? Thank you in advance.

 

[Debra Dalgleish]

If you're trying to pull one value for each day, and create the chart
from that, you can do the following:

Create a blank summary sheet for the chart data.
In cell E3, enter this formula: =TODAY()
In cell D3, enter: =E3-1
Select cell D3, point to the fill handle (the small black square
at the bottom right of the selection), and drag back to A3

In cell A1, enter: =TEXT(A3,"mmmm")
Copy this formula across to cell E1

In cell A4, enter: =VLOOKUP(A3,INDIRECT(A1&"!$A$2:$B$31"),2,0)
Copy this formula across to cell E4

Select cell A3:E4, and click the Chart Wizard button.
Follow the steps to create your chart.