If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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$20 000),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? |
#2
|
|||
|
|||
can you create a dynamic chart in an xlt templet
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 "mark1035" wrote: I have set up a dynamic chart using the Defined Name =OFFSET(Template!$C$#,,,COUNTA(Template!$C$3:$C$20 000),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? |
Thread Tools | |
Display Modes | |
|
|