Dynamic Chart Problem

[Brian]

Hi everybody,

I tried Tushar Mehta's approach to creating dynamic charts, and it
seems to work perfectly. However, when I go to save the Excel
spreadsheet, I get this error: "Your formula contains an invalid
external reference to a worksheet. Verify that the path, workbook, and
range name or cell reference are correct and try again".

Here are the named ranges I've created (rangeName: refers to formula)
XValues: OFFSET('ALL GROUP DATA'!$E$1,0,COUNTA('ALL GROUP
DATA'!$E16:$AS16)-'AEE INDICES SUMMARY'!$C$62,1,'AEE INDICES
SUMMARY'!$C$62)
aYValues: =OFFSET(XValues,6,0)
bYValues: =OFFSET(XValues,14,0)

The first chart has XValues vs. aYValues, while the second chart has
XValues vs. bYValues. Could the error be that I'm using the same named
range (XValues) for both charts?

I'm quite stuck here. Can anybody help?

Thanks in advance.
Brian

 

[Brian]

Hi everybody,

I tried Tushar Mehta's approach to creating dynamic charts, and it
seems to work perfectly. However, when I go to save the Excel
spreadsheet, I get this error: "Your formula contains an invalid
external reference to a worksheet. Verify that the path, workbook, and
range name or cell reference are correct and try again".

Here are the named ranges I've created (rangeName: refers to formula)
XValues: OFFSET('ALL GROUP DATA'!$E$1,0,COUNTA('ALL GROUP
DATA'!$E16:$AS16)-'AEE INDICES SUMMARY'!$C$62,1,'AEE INDICES
SUMMARY'!$C$62)
aYValues: =OFFSET(XValues,6,0)
bYValues: =OFFSET(XValues,14,0)

The first chart has XValues vs. aYValues, while the second chart has
XValues vs. bYValues. Could the error be that I'm using the same named
range (XValues) for both charts?

I'm quite stuck here. Can anybody help?

Thanks in advance.
Brian

It seems that when I type or delete even a single character in an
adjacent cell (ie make a change of any sort), the graph data
re-appears. Why is this?

Thanks again.
Brian

 

[Brian]

It seems that when I type or delete even a single character in an
adjacent cell (ie make a change of any sort), the graph data
re-appears. Why is this?

Thanks again.
Brian