Diagram stops actualizing

%3CLINGO-SUB%20id%3D%22lingo-sub-2117055%22%20slang%3D%22en-US%22%3EDiagram%20stops%20actualizing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117055%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Microsoft%20365%20on%20a%20Windows%2010%20computer.%20In%20Excel%20I%20have%20a%20table%20and%20an%20associated%20line%20diagram.%20In%20the%20table%20there%20is%20one%20number%20entry%20for%20each%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20clicking%20onto%20the%20data%20line%20in%20the%20diagram%20its%20formula%20is%20shown%20as%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DDATENREIHE(%22Gewicht%20JCZ%22%3B%3BJCZ!%24L%248%3A%24L%243284%3B8)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20a%20few%20days%20ago%20the%20diagram%20has%20stopped%20actualizing.%20The%20daily%20entries%20are%20simply%20not%20shown%20in%20the%20diagram.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20find%20a%20cause%20I%20have%20used%20the%20Windows%20File%20History%20and%20restored%20the%20file%20for%20the%20last%20day%20the%20diagram%20had%20worked.%20The%20formula%20for%20the%20diagram%20is%20exactly%20the%20same%20and%20I%20can%20vary%20the%20daily%20entries%20up%20and%20down%20at%20will%20with%20the%20diagram%20faithfully%20following%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENothing%20has%20been%20changed%20on%20my%20computer%20sincd%20the%20problem%20started.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anybody%20know%20who%20I%20could%20get%20things%20working%20again%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohannes%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2117055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I am using Microsoft 365 on a Windows 10 computer. In Excel I have a table and an associated line diagram. In the table there is one number entry for each day.

 

On clicking onto the data line in the diagram its formula is shown as 

 

=DATENREIHE("Gewicht JCZ";;JCZ!$L$8:$L$3284;8)

 

Since a few days ago the diagram has stopped actualizing. The daily entries are simply not shown in the diagram.

 

Trying to find a cause I have used the Windows File History and restored the file for the last day the diagram had worked. The formula for the diagram is exactly the same and I can vary the daily entries up and down at will with the diagram faithfully following up.

 

Nothing has been changed on my computer sincd the problem started.

 

Does anybody know who I could get things working again?

 

Thanks in advance,

 

Johannes

0 Replies