An update
Public WkCol As String
Sub Auto_open()
WkCol = "B"
UpdateChart1 (WkCol)
End Sub
Sub ChangeChart1()
If (Cells(1, Columns.Count).End(xlToLeft).Column <> Cells(1, WkCol).Column) Then _
WkCol = Split(Cells(1, Cells(1, WkCol).Column + 1).Address, "$")(1)
UpdateChart1 (WkCol)
End Sub
Sub ChangeChart2()
If (WkCol <> "B") Then _
WkCol = Split(Cells(1, Cells(1, WkCol).Column - 1).Address, "$")(1)
UpdateChart1 (WkCol)
End Sub
Sub UpdateChart1(NwCol As String)
Const Fom = "SERIES(Sheet1!$#$1,Sheet1!$A$2:$A$µ,Sheet1!$#$2:$#$µ,1)"
Dim LR As Long
LR = Cells(Rows.Count, 1).End(3).Row
T = Replace(Fom, "µ", LR)
T = Replace(T, "#", NwCol)
ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).Formula = "=" & T
ActiveSheet.Cells(1, WkCol).Select
End Sub
Bookmarks