Diagramme fixieren / mitscrollen lassen

%3CLINGO-SUB%20id%3D%22lingo-sub-1573798%22%20slang%3D%22de-DE%22%3EFix%20diagrams%20%2F%20scroll%20along%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573798%22%20slang%3D%22de-DE%22%3E%3CP%3EDear%20Community%2C%20I%20have%20a%20table%20with%20many%20rows.%20This%20includes%20a%20diagram.%20But%20if%20I'm%20in%20the%20current%20line%2C..%20Such%20as.%20350%20entries%20I%20miss%20so%20far%20again%20and%20again%20either%20scroll%20up%20to%20see%20the%20chart%2C%20or%20drag%20the%20chart%20down%20to%20the%20area%20where%20I%20record%20data.%20Is%20there%20a%20way%20to%20fix%20the%20chart%20on%20the%20screen%20so%20that%20it%20always%20stays%20in%20the%20same%20position%20no%20matter%20how%20up%20or%20down%20I%20scroll%3F%20Is%20that%20understandable%3F!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPicture%3A%20Chart%20stays%20where%20I%20put%20it%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22santandor_0-1596830841533.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F211028i7DA4DE6817BFBBC2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22santandor_0-1596830841533.png%22%20alt%3D%22santandor_0-1596830841533.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPicture%3A%20Ideal%3A%20The%20chart%20scrolls%20down...%20How%20does%20that%20work%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22santandor_1-1596831280341.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F211029iA2FAC7F8C0D8BC1F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22santandor_1-1596831280341.png%22%20alt%3D%22santandor_1-1596831280341.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20hope%20for%20some%20good%20tips!%20Thank%20you%20very%20much.%20Santandor%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1573798%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576456%22%20slang%3D%22en-US%22%3ERe%3A%20Diagramme%20fixieren%20%2F%20mitscrollen%20lassen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576456%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753005%22%20target%3D%22_blank%22%3E%40santandor%3C%2FA%3E%26nbsp%3B%2C%20the%20method%20is%20in%20english%20but%20i%20hope%20you%20can%20follow%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20Go%20to%20View%20tab%20%26amp%3B%20Click%20%22New%20Window%22%20(see%20image%201)%3C%2FP%3E%3CP%3E2)%20You%20will%20note%20that%20a%20duplicate%20window%20of%20same%20file%20opened%20like%20this%20(see%20image%202)%3C%2FP%3E%3CP%3E3)%20Again%20go%20to%20View%20tab%20and%20click%20%22Arrange%20All%22%2C%20then%20in%20the%20dialogue%20box%2C%20click%20%22vertical%22%20and%20%22windows%20of%20active%20workbook%22%20and%20then%20click%20%22OK%22%20(see%20image%203)%3C%2FP%3E%3CP%3E4)%20You%20will%20note%20that%20now%20same%20file%20is%20shown%20twice%20side%20by%20side%20like%20this%20(see%20image%204)%3C%2FP%3E%3CP%3E5)%20If%20you%20scroll%20down%20on%20left%20file%2C%20the%20right%20file%20remains%20at%20same%20position.%20So%20e.g.%20i%20go%20to%20row%20no.%20121-122%20%2C%20the%20chart%20is%20still%20visible%20on%20the%20right%20window%20(see%20image%205)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576457%22%20slang%3D%22en-US%22%3ERe%3A%20Diagramme%20fixieren%20%2F%20mitscrollen%20lassen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576457%22%20slang%3D%22en-US%22%3E%3CP%3Esending%20image%201%20again%20as%20it%20seems%20to%20be%20not%20uploaded%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

Liebe Community, Ich habe eine Tabelle mit vielen Zeilen. Dazu gehört ein Diagramm. Wenn ich aber in der aktuellen Zeile,.. z.B. 350 etwas eintrage miss ich bisher immer wieder entweder hochscrollen um das Diagramm zu sehen, oder mir das Diagramm mit nach unten ziehen zu dem Bereich wo ich Daten eintrage. Gibt es eine Möglichkeit das Diagramm so auf dem Bildschirm zu fixieren, dass es immer an der gleichen Position bleibt egal wie hoch oder runter ich scrolle? Ist das verständlich?!

 

Bild: Diagramm bleibt da wo ich es hinschiebe santandor_0-1596830841533.png

 

Bild: Ideal: Das Diagramm scrollt mit runter... WIE GEHT DAS?

santandor_1-1596831280341.png

Ich hoffe auf ein paar gute Tipps! Vielen Dank. Santandor

 

2 Replies
Highlighted

@santandor , the method is in english but i hope you can follow it.

 

1) Go to View tab & Click "New Window" (see image 1)

2) You will note that a duplicate window of same file opened like this (see image 2)

3) Again go to View tab and click "Arrange All", then in the dialogue box, click "vertical" and "windows of active workbook" and then click "OK" (see image 3)

4) You will note that now same file is shown twice side by side like this (see image 4)

5) If you scroll down on left file, the right file remains at same position. So e.g. i go to row no. 121-122 , the chart is still visible on the right window (see image 5)

 

 

Highlighted

sending image 1 again as it seems to be not uploaded