Rolling X Day Chart

[JordanR]

Clearly I'm missing something. Using Excel 2k7, I have a named range - DDI_Con with the following formula =OFFSET('DI'!$D$1, COUNTA('DI'!$D:$D)-90,0,90,1)
Reference that in a chart and I get just what I want, a graph that shows me the last 90 days.

Problem is that I can't get the x-axis to show the date range to match. I've tried setting up another named range (DDI_Date) with the following formula =OFFSET('DI'!$C$1, COUNTA('DI'!$C:$C)-90,0,30,1). When I try to call DDI_Date from within the chart data screen it just puts the word "DDI_Date" in the x-axis.
Guessing I can't use named ranges this way?

 

[chergh]

Try:

=OFFSET(DI!$D$1,IF( COUNTA(DI!$D:$D)>=90,COUNTA(DI!$D:$D)-90,0),0,MIN(COUNTA(DI!$D:$D),90),1)

 

[JordanR]

I played with something like this as well. It worked, but it still didn't give me the date on the x-axis. Am I missing something obvious?