graph Excel à la fin d'un document word
Private Sub CommandButton1_Click() Dim salesChart As Chart Dim oRng As Word.Document Dim oRngRange As Range Dim chartWorkSheet As Excel.Worksheet Set chartWorkSheet = salesChart.ChartData.Workbook.Worksheets(1) Selection.GoTo What:=wdGoToPage, Which:=wdGolast salesChart.ChartType = xlRadarMarkers 'chartWorkSheet.ListObjects("Table1").Resize chartWorkSheet.Range("A1:B5") 'chartWorkSheet.Range("Table1[#Headers,[Series 1]]").FormulaR1C1 = "Sales" chartWorkSheet.Range("A2").FormulaR1C1 = "Bikes" chartWorkSheet.Range("A3").FormulaR1C1 = "Accessories" chartWorkSheet.Range("A4").FormulaR1C1 = "Repairs" chartWorkSheet.Range("A5").FormulaR1C1 = "coucou" chartWorkSheet.Range("B2").FormulaR1C1 = QUANTITE chartWorkSheet.Range("B3").FormulaR1C1 = "2500" chartWorkSheet.Range("B4").FormulaR1C1 = "4000" chartWorkSheet.Range("B5").FormulaR1C1 = "3000" Set salesChart = ActiveDocument.Shapes.AddChart.Chart