How to Keep a Chart (or Charts) Visible when Scrolling in Excel?

📽️In this video tutorial I explain how to keep a chart visible when scrolling up or down through a worksheet.

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍

Download the featured file here (the code is included in the workbook): https://www.bluepecantraining.com/wp-content/uploads/2022/11/Chart-Scrolls.zip

VBA Code
-----------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveWindow.VisibleRange ActiveSheet.ChartObjects("Chart 2").Top = .Top + 5
ActiveSheet.ChartObjects("Chart 2").Left = .Left + 200
ActiveSheet.ChartObjects("Chart 3").Top = .Top + 5 'Use the code below to stack columns vertically (remove apostrophe & delete the line of code above) 'ActiveSheet.ChartObjects("Chart 3").Top =
ActiveSheet.ChartObjects("Chart 2").Height + .Top + 20
ActiveSheet.ChartObjects("Chart 3").Left = .Left + 200 'Use the code below to place charts side by side (remove apostrophe & delete the line of code above) 'ActiveSheet.ChartObjects("Chart 3").Left =
ActiveSheet.ChartObjects("Chart 2").Width + .Left + 225
End With
End Sub
-----------------------------------------------------------------

🕰️Timestamps
00:00 - Introduction
00:18 - METHOD 1: Freeze Panes
00:49 - METHOD 2: VBA
------------------------

Видео How to Keep a Chart (or Charts) Visible when Scrolling in Excel? канала Chester Tugwell