Sub Macro1() Application.DisplayAlerts = False Dim Data1 As String, Data2 As String ActiveSheet.ChartObjects("Graphique 11").Activate ActiveChart.SeriesCollection(1).Trendlines(1).Select Selection.Delete ActiveChart.SeriesCollection(1).Select ActiveChart.SeriesCollection(1).Trendlines.Add(Type:=xlPower, Forward:=0, _ Backward:=0, _ DisplayEquation:=True, _ DisplayRSquared:=True).Select Data1 = ActiveChart.SeriesCollection(1).Trendlines(1).DataLabel.Text Sheets("Data").Range("W31").Value = Data1 Range("W31").Select With Selection .HorizontalAlignment = xlGeneral .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = False End With Selection.TextToColumns _ Destination:=Range("X31"), _ DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, _ Tab:=False, _ Semicolon:=False, _ Comma:=False, _ Space:=False, _ Other:=True, _ OtherChar:="x", _ FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), _ TrailingMinusNumbers:=True Range("Y31").Select Selection.Copy Range("P31").Select Selection.PasteSpecial _ Paste:=xlPasteValues, _ Operation:=xlNone, _ SkipBlanks:=False, _ Transpose:=False Application.CutCopyMode = False ActiveSheet.ChartObjects("Graphique 11").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).Trendlines(1).DataLabel.Select Selection.Delete
ActiveSheet.ChartObjects("Graphique 1").Activate ActiveChart.SeriesCollection(1).Trendlines(1).DataLabel.Select ActiveWindow.Visible = False Windows("Classeur1").Activate Range("D7").Select ActiveSheet.Paste
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim Data as String Data = ActiveChart.SeriesCollection(1).Trendlines(1).DataLabel.Text Sheets("Data").Range("W31").Value = Data