Hi,
I am trying to create a Dynamic Chart using named ranges.
1. I created two named ranges as follow:
CatX - workbook scope, with the formula: =OFFSET(INDIRECT("'Week Data'!$B$" & Metas!$C$4+2);0;0;Metas!$C$5-Metas!$C$4;1)
CatY - workbook scope, with the formula: =OFFSET(INDIRECT("'WeekData'!$G$" & Metas!$C$4+2);0;0;Metas!$C$5-Metas!$C$4;1)
There are sheets called 'Week Data' and 'Metas'
When I use CatX or CatY or both in the SERIE of a column chart, like this:
=SERIE($G$2;CatX;CatY;1)
it shows an error message.
I have tested parts of the Offset formula and they worked. Like those:
=INDIRECT("'Week Data'!$B$" & Metas!$C$4+2)
=sum( OFFSET(INDIRECT("'WeekData'!$G$" & Metas!$C$4+2);0;0;Metas!$C$5-Metas!$C$4;1) )
Where is the error?
Thanks.
Carlos César tanaka
Curso de Excel / Access
MPR Informática
I am trying to create a Dynamic Chart using named ranges.
1. I created two named ranges as follow:
CatX - workbook scope, with the formula: =OFFSET(INDIRECT("'Week Data'!$B$" & Metas!$C$4+2);0;0;Metas!$C$5-Metas!$C$4;1)
CatY - workbook scope, with the formula: =OFFSET(INDIRECT("'WeekData'!$G$" & Metas!$C$4+2);0;0;Metas!$C$5-Metas!$C$4;1)
There are sheets called 'Week Data' and 'Metas'
When I use CatX or CatY or both in the SERIE of a column chart, like this:
=SERIE($G$2;CatX;CatY;1)
it shows an error message.
I have tested parts of the Offset formula and they worked. Like those:
=INDIRECT("'Week Data'!$B$" & Metas!$C$4+2)
=sum( OFFSET(INDIRECT("'WeekData'!$G$" & Metas!$C$4+2);0;0;Metas!$C$5-Metas!$C$4;1) )
Where is the error?
Thanks.
Carlos César tanaka
Curso de Excel / Access
MPR Informática