chart based on time - excel

[ripvanfish]

I have a list of data corresponding to dates (in an excel table), and I only want to chart the last 60 days, any suggestions on the easiest way to do this?

Thanks!

 

[ETID]

I would add a Column called &quot;Elapsed Days <= 60&quot;


then in it (assuming your date is in col A)
type =IF(DATEDIF(A1,NOW(),&quot;D&quot<=60,DATEDIF(A1,NOW(),&quot;D&quot,&quot;&quot

then run a pivot chart on this data,..filtering out the (blanks) in the &quot;Elapsed Days <= 60&quot; column