'' graphique ActiveSheet.Shapes.AddChart.Select ActiveChart.ChartType = xl3DColumnClustered Dim sel1 As String Dim sel2 As String '' rwdown = Range("C41").End(xlDown).Row ''mon tableau de donnée commence en C41 eszt se finit en en "C" & rwdown For rw = 41 To rwdown Step 2 sel1 = sel1 & "D" & rw & "," Next rw ''on enléve la dernière virgule Lsel1 = Len(sel1) sel1 = Left(sel1, Lsel1 - 1) '' For rw = 42 To rwdown Step 2 sel2 = sel2 & "D" & rw & "," Next rw ''on enléve la dernière virgule Lsel2 = Len(sel2) sel2 = Left(sel2, Lsel2 - 1) ''serie 1 en rouge ActiveChart.SeriesCollection.NewSeries ActiveChart.ChartType = xl3DColumnClustered ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).Values = Range(sel1) ActiveChart.SeriesCollection(1).Interior.ColorIndex = 5 ''serie 2 en bleu ActiveChart.SeriesCollection.NewSeries ActiveChart.ChartType = xl3DColumnClustered ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(2).Values = Range(sel2) ActiveChart.SeriesCollection(2).Interior.ColorIndex = 3 Next rw
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question