In this video tutorial I explain how to keep a chart visible when scrolling up or down through a worksheet. I explore two methods:
Click here to download the featured file (including code)
Video Table of Contents
00:00 – Introduction
00:18 – METHOD 1: Freeze Panes
00:49 – METHOD 2: VBA – see code below
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