Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create a templet? | Excel Worksheet Functions | |||
Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
how to create a chart from a dynamic table of data? | Charts and Charting in Excel | |||
How do I create a dynamic chart | Charts and Charting in Excel | |||
How to create a dynamic chart using data from every 7th data row | Charts and Charting in Excel |