Dynamic Chart Problem

  • Thread starter Thread starter Brian
  • Start date Start date
B

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 said:
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
Click to expand...

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
 
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
 
Back
Top