Chart Between Two Variable Dates

[andrewc]

Hi,

I have data in columns A:B that I would like to use to create a line chart between the two dates stipulated in cells P2 and P3.

The way that the data is to be calculated for use in the chart is shown in column E: the value associated with the start date (as stipulated in P2) should be equal to zero and the subsequent values compounded as shown in cells E4 and below.

I would like to create a chart that will update automatically using the data in A:B when I change the dates in P2:PŁ, without the need to use the "helper" columns D:E.

Can someone please suggest a solution?

Thanks very much!