Sub graph_pluietotale_mini_maxi()
Dim F1 As Worksheet, F2 As Worksheet
Set F1 = Worksheets(Feuil3.Name)
Set F2 = Worksheets(Feuil6.Name)
Application.ScreenUpdating = False
On Error Resume Next
F2.Shapes("Graphique1").Delete
Charts.Add
With ActiveChart
    .ChartType = xlLine
    .SeriesCollection.NewSeries
    .SeriesCollection(1).XValues = F1.Range("A2", F1.[A2].End(xlDown))
    .SeriesCollection(1).Values = F1.Range("L2", F1.[L2].End(xlDown))
    .SeriesCollection(1).Name = F1.Range("L1")
    .Location Where:=xlLocationAsObject, Name:="graph.mini-maxi"
    End With
 ActiveSheet.ChartObjects("Graphique1").Activate
    ActiveChart.PlotArea.Select
    ActiveChart.Axes(xlValue).CrossesAt =[COLOR="Red"] -30[/COLOR]
    ActiveChart.Axes(xlCategory).TickLabelSpacing = [COLOR="Red"]10[/COLOR]
    ActiveChart.ChartTitle.Delete
    ActiveSheet.ChartObjects("Graphique1").Activate
    ActiveChart.ChartArea.Select
ActiveChart.Parent.Name = "Graphique1"
With ActiveSheet.Shapes("Graphique1")
    .Left = 0
    .Top = 0
    .Width = [COLOR="Red"]1240[/COLOR]
    .Height =[COLOR="Red"] 600[/COLOR]
End With
[A1].Select
End Sub