How to always keep a chart in view when scrolling in Excel?

If there is a chart inserted in a sheet, while you scrolling the sheet down to view the data, the chart cannot be viewed at the same time as below screenshot shown, which must be nasty. In this article, I introduce a VBA code to keep a chart always in view even though scrolling the sheet down or up.

Always keep a chart in view

Always keep a chart in view

To retain a chart in view while scrolling sheet, you can apply below VBA code to solve it.

1. Right click at sheet tab that you want to keep the chart visible, and click View Code form the context menu. See screenshot:

2. In the popping Microsoft Visual Basic for Applications window, paste below code to the blank script.

VBA: Keep chart always in view

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'UpdatebyExtendoffice20161111
    Dim CPos As Double
    Application.ScreenUpdating = False
    CPos = ActiveWindow.ScrollRow * ActiveCell.RowHeight
    ActiveSheet.ChartObjects("Chart 2").Activate
    ActiveSheet.Shapes("Chart 2").Top = CPos
    ActiveWindow.Visible = False
    Application.ScreenUpdating = True
End Sub

3. Save and close the dialog, then the chart will be moved down or up as you clicking at any cell.

Notes:

(1) In the VBA code, Chart 2 is the chart name you want to keep in view, you can change it as you need.

(2) This VBA cannot always keep a group of charts in view.