Thread: Excel graph will not accept dynamic function

Background:
My job requires an engine analysis, called a Short Term Engine Trend Monitoring Program (STETMP), to predict when the next malfunction occurs. This analysis is made for two aircraft explaining the 2 files.

The goal:
To create a line in a graph that shows the value of the Outside Air Temperature (OAT) for the number of entries given (if unclear refere to the excel sheet "PH-CGC STETMP.xlsx").

The problem:
The OAT line in the graph of "PH-CGN STETMP.xlsx" will not accept the same formula used in the graph of "PH-CGC STETMP.xlsx" (which does work) with some slight adjustments for proper references.

If more details are required feel free to ask. Note: the password for PH-CGC STETMP.xlsx is 8183 and the password for PH-CGN STETMP.xlsx is 8181.

Assistance is much appreciated since I do not know how to solve this puzzle.

Thank you in advance,
Viktor Knoben

PS: be sure to download the files due to invalid references!

*SOLVED*
The solution was to copy the files to another computer and to perform the exact same steps as before. I have absolutely no clue why it did not work on my laptop, desktop and work desktop but all that matters is that the problem is solved!

What formula did you try? It works fine for me after adjusting sheet, workbook and cell references.

PH-CGC:

Names
=COUNT('PH-CGC'!$A:$A) named COUNTER
=(OFFSET('PH-CGC'!$D$5,0,0,('PH-CGC STETMP.xlsx'!COUNTER),1))+200 named yasd

Graph
='PH-CGC'!$D$4 as the name
='PH-CGC STETMP.xlsx'!yasd as the value

PH-CGN (non functioning):

Names
=COUNT('PH-CGN'!$A:$A) named COUNTERN
=(OFFSET('PH-CGN'!$L$5,0,0,('PH-CGN STETMP.xlsx'!COUNTERN),1))+200 named yasln

Graph
='PH-CGN'!$L$4 as the name
='PH-CGN STETMP.xlsx'!yasln as the value (but excel wont accept this and does not provide an error)