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

=Fault_occur.xlt!Labels

, 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)

Chart
Data

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

Series

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.

cheers

Andy

Since I didn't see what you started with, take a look @ http://j-walk.com/ss/excel/usertips/tip053.htm

Hope that helps,

Smitty