I wanted to create a template of an Column Graph including a Status-Panel that gives information of the sum and average of all shown bars etc. But the script that is attached to this panel needs the name of the worksheet the graph belongs to. So when I use this template to create a graph of any worksheet, the panel-script won't work until correcting the wks.-name in the script. If you know an global variable or an object-property which contains the worksheet- name of a graph I would be grateful for every tip. here is my actual panel script: (How can I extract the WORKSHEETNAME of an graph)
--------------------------------------------- sum ([WORKSHEETNAME]_B); myPanel.v1=sum.total; myPanel.v2=sum.total/[WORKSHEETNAME]!Wks.maxRows;