1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| Sub Barre_erreur()
' Barre_erreur Macro
ActiveSheet.ChartObjects("Graphique BFu").Activate
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(8).Values = "=Données!$I$1"
ActiveChart.SeriesCollection(8).Select
ActiveChart.SeriesCollection(8).ChartType = xlXYScatterLinesNoMarkers
ActiveChart.SeriesCollection(8).Select
ActiveChart.SeriesCollection(8).HasErrorBars = True
ActiveChart.SeriesCollection(8).ErrorBars.Select
ActiveChart.SeriesCollection(8).ErrorBar Direction:=xlY, Include:=xlMinusValues, Type:=xlFixedValue, Amount:=1
With Selection.Border
.Weight = xlThick ' 4 valeurs possibles xlHairline, xlThin, xlMedium, xlThick
.Color = RGB(179, 162, 199)
End With
ActiveChart.SeriesCollection(8).ErrorBars.Select
ActiveChart.SeriesCollection(8).ErrorBars.EndStyle = xlNoCap
ActiveChart.SeriesCollection(8).ErrorBar Direction:=xlX, Include:= _
xlPlusValues, Type:=xlFixedValue, Amount:=(ThisWorkbook.ActiveSheet.Range("I2").Value)
With Selection.Border
.Weight = xlThick ' 4 valeurs possibles xlHairline, xlThin, xlMedium, xlThick
.Color = RGB(255, 0, 0)
End With
End Sub |
Partager