Formula in Chart Range

[jagostinho]

Hello,

I am trying to create a dynamic range for a particular chart.

If the following is pasted into a cell the correct range is selected.

=Sheet1!$A$4:$A$10,OFFSET(Sheet1!$E$4,0,0,7,COUNTA($E$4:$ZZ$4))

But if I try to paste it into the chart range I get an error. see image below.

What step am I missing here?

Thank you for your help.

Chart Dynamic Range.png

[Andy Pope]

Have a read of this
http://peltiertech.com/dynamic-charts/

You have use a named range and then reference that in the series formula. You can not have formula directly in the series formula