Relative Chart References

[sentimentrader]

Hello,

I would like to have a chart update automatically when I add more data, with a fixed number of data points. For example, when I add data, I would like the chart range to only reflect, say, the past 30 days, and not just add the latest data to the existing data range.

I know this is possible and I think I'm close, but I just can't get it to work.

Thanks for any help.

 

[Mark W.]

Why don't you summarize your data using a PivotTable and create your chart from it?

 

[sentimentrader]

One of the columns is a formula based on other data, so I would rather keep it in a straight column basis...

 

[Mark W.]

Sorry, I don't follow your reasoning. See below...

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Value	InRange?			InRange?	TRUE
2	9/1/2002	83	FALSE
3	9/8/2002	19	FALSE			SumofValue
4	9/15/2002	20	FALSE			Date	Total
5	9/22/2002	98	FALSE			9/29/2002	34
6	9/29/2002	34	TRUE			10/6/2002	27
7	10/6/2002	27	TRUE			10/13/2002	86
8	10/13/2002	86	TRUE			10/20/2002	34
9	10/20/2002	34	TRUE			10/27/2002	88
10	10/27/2002	88	TRUE
11
Sheet2