charting more than one worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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