Error when trying to graph

[declan1983]

I have run into somewhat of an empty cell dead end. I have been beating it back and forth and thought I was there but then not so much. I will try to explain what is going on:

I select a variable on sheet2 (Be or Bew), this variable then poulates a cell on Sheet3. The following formula then populates the named range

Please Login or Register  to view this content.

So while there is a value for Be or Bew everything works great and even showing empty cells works well. The issue comes when I try to graph the results. In the image below data B23:B27 - A_EdgeLimits_x01 and C23:C27 - A_EdgeLimits_y01 etc.

These names ranges are defined with the formula

Please Login or Register  to view this content.

these are then used in graphs as x and y axis. The issue occurs when I hit the empty cells, when I try to enter an x or y named range it gives me an error saying "Excel found a problem with one or more formula references in the workbook".

I have hit my head against a wall most of the day trying to figure it out but have go nowhere. I have a feeling that it is an issue with the offset formula but I am not sure.

sheet3.PNG

[Limor_OP]

you need to upload the file, please see the yellow banner at the top or instructions.

[declan1983]

I have attached the file.