Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    225

    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

    =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

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •