Dim Plage As Range
With Sheets("Calcul")
Set Plage = Union(Range(.Cells(112, 1), .Cells(134, 1)), Range(.Cells(112, 2), .Cells(134, 7)))
End With
Charts.Add
ActiveChart.ChartType = xlBarClustered
ActiveChart.SetSourceData Source:=Plage, PlotBy:=xlColumns