Dynamic charts in Excel

**cbeck** · 08-02-2011, 02:44 PM

I have created this chart that is dependent on the dates chosen in cells B2, B3. The data for the charts is populated in columns K and L. The chart populates accurately, if the dates chosen starts with 1/1/11 but any date after (ie 2/1/11) and I receive a flat line of data before the spike in February.

I know that the chart is reading the data (even though it is blank - or at least just a formula) prior to 2/1 but is it possible to just have the chart start on 2/1?

Any insight would be greatly appreciated.
thanks
cbeck

**Andy Pope** · 08-03-2011, 06:48 AM

You need to have a dynamic row start position.

Fans_Range: =OFFSET(Sheet1!$L$2,Sheet1!$I$3-1,0,COUNT(Sheet1!$L:$L),1)

Where the formula in I3 is

=MATCH(B2,K2:K366,0)

You also need to update the named range for axis labels.