can you create a dynamic chart in an xlt templet



I have set up a dynamic chart using the Defined Name
=OFFSET(Template!$C$#,,,COUNTA(Template!$C$3:$C$20000),1) Named datalabel,
and Defined Name =OFFSET(datalabel,0,1) Named data. These named ranges where
saved in chart1.xls and worked fine. However, When I re-created the same
Defined Names in chart 2.xlt and tried use them in a chart, a message
returned Referrence not valid, Work book must be open? chart2.xlt was open?



Tushar Mehta

Is 'Template' the name of the worksheet or the workbook? If the former, it
should work -- I just verified it. If the latter, change your workbook so
that the defined names have a scope of the worksheet. To create such a
defined name, define the name as {worksheet name}!{actual name} rather than
just {actual name}.
Tushar Mehta
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question