Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim Col$, Lig&
If Target.Row = 1 And Target.Column > 1 And Target <> "" Then
Col = Split(Cells(, Target.Column).Address, "$")(1)
Lig = Cells(Rows.Count, Col).End(3).Row
ActiveSheet.ChartObjects("Graphique 1").Activate
ActiveChart.FullSeriesCollection(1).Select
ActiveChart.FullSeriesCollection(1).Values = "=Feuil1!$" & Col & "$3"
ActiveChart.FullSeriesCollection(2).Values = "=Feuil1!$" & Col & "$2"
ActiveChart.FullSeriesCollection(3).Values = "=Feuil1!$" & Col & "$4:$" & Col & "$" & Lig
End If
End Sub