Drawing chart for the period

Hello guys,

My task it to create simple line chart for the specified data range. Unfortunately I don't know how to realize this without manual work.

Can anybody help me?

p.s. I've attached simple example for your convinience.

Thanks in advance.

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