Drawing chart for the period

Hello,

You can create a dynamic chart thus:

Define two dynamic range names

ChtLabels =INDEX(Sheet1!$A:$A,MATCH(Sheet1!$E$1,Sheet1!$A:$A,1)):INDEX(Sheet1!$A:$A,MATCH(Sheet1!$E$2,Sheet1!$A:$A,1))

ChtData =OFFSET(ChtLabels,0,1)

Then edit your chart data source and enter

=Sheet1!ChtLabels

as the category and

=Sheet1!ChtData

as the series values.

For more information about dynamic charts, check out http://peltiertech.com/Excel/Charts/Dynamics.html


See attached