can you create a dynamic chart in an xlt templet

M

mark1035

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?
 
T

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
http://www.tushar-mehta.com
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

Top