Dynamic chart
 

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?

Dynamic chart
 

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.
--
Thanks,
Shane Devenshire


"BK13" wrote:

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?

Dynamic chart
 

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!

"ShaneDevenshire" wrote:

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.
--
Thanks,
Shane Devenshire


"BK13" wrote:

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?