Dynamic chart

[BK13]

I need to be able to create a rolling 30 day chart. I have looked at some of
the postings online and found them to be very helpful.
I need to make a slight modification to do look at days rather than months.
I am utilizing NAMES. here is my chtCar
code:=IF(Sheet1!$A$2:$A$75=(TODAY()),OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A:$A)-1,0,-MIN(chtlen,COUNTA(Sheet1!$A:$A)-1),1))
I think I am close however I get FALSE in my results.

I need help! any suggestions?

 

[ShaneDevenshire]

Hi,

You might try something like this, where your dates are in A1:A500 and your
data is in B1:B500. This formula returns an array of the 30 dates starting
on todays date (note A1 is a date).

=OFFSET(A1,MATCH(TODAY()-1,A1:A500,0),0,30)
=OFFSET(A1,MATCH(TODAY()-1,A1:A159,0),1,30)

The second formula return an array of the 30 date's data.

If this helps please click the Yes button.

 

[BK13]

Shane,

Thank you very much that did the trick- I just had to change the "30" to
"-30" to give me today and the previous 30 days.
Now off to my next task!
Thanks again!