var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Charting Data that can Grow - XLT
right, i have had a look at the examples you have sent me thanks....
however i am still a little stuck.
whenever i try to enter the data into the Graph Source data boxes
, i get the following message:
Your formulacontains an invalid external refernece to a worksheet.
Verify the path, Workbook and range name or cell reference are correct. and try again
my workbook is set up as follows:
Title : Fault_Occur.xlt
Worksheets: (2 of)
Named Ranges: (2 of)
Labels - =OFFSET(Data!$A$2,,,COUNTA(Data!$A$2:$A$200),1)
Values - =OFFSET(Data!$E$2,,,COUNTA(Data!$E$2:$E$200),1)
the trouble i seem to get happens when i try to change the source data on the graph page.
currently i have
Data Range - =Data!$A$1:$A$20,Data!$E$1:$E$20
Name - =Data!$E$1
Values - =Data!$E$2:$E$20
Category x Labels - =Data!$A$2:$A$20
please help this is reallt doing my head in....
happy to email my template to anyone that can help.
Since I didn't see what you started with, take a look @ http://j-walk.com/ss/excel/usertips/tip053.htm
Hope that helps,