Sub SelectionAdheren()
Dim r1 As Range
Range("A6:A2000").Select
Selection.Find(what:=Range("B1").Value, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
ActiveCell.Select
'Windows("Copie de +10 Centre.xls").SmallScroll Down:=8
ActiveWindow.Visible = False
Windows("Copie de +10 Centre.xls").Activate
' Range("E33
33").Select
Range(ActiveCell(1, 5), ActiveCell(1, 16)).Select
r1 = Range(ActiveCell(1, 5), ActiveCell(1, 16))
Charts.Add
ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:= _
"Courbes - Histogramme"
' ActiveChart.SetSourceData Source:=Sheets("consolidation").Range("E3333"), _
PlotBy:=xlRows
ActiveChart.SetSourceData Source:=Sheets("consolidation").activecellSelection, _
PlotBy:=xlRows
' ActiveChart.SeriesCollection(1).Delete
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(1).Values = _
"=(consolidation!RC5,consolidation!RC9,consolidation!RC13)"
ActiveChart.SeriesCollection(1).Name = "=consolidation!R4C5"
ActiveChart.SeriesCollection(2).Values = _
"=(consolidation!RC7,consolidation!RC11,consolidation!RC15)"
ActiveChart.SeriesCollection(2).Name = "=consolidation!R4C7"
ActiveChart.SeriesCollection(3).Values = _
"=(consolidation!RC6,consolidation!RC10,consolidation!RC14)"
ActiveChart.SeriesCollection(3).Name = "=consolidation!R4C6"
ActiveChart.SeriesCollection(4).Values = _
"=(consolidation!RC8,consolidation!RC12,consolidation!RC16)"
ActiveChart.SeriesCollection(4).Name = "=consolidation!R4C8"
ActiveChart.SeriesCollection(1).XValues = _
"=(consolidation!R3C5,consolidation!R3C9,consolidation!R3C13)"
ActiveChart.SeriesCollection(2).XValues = _
"=(consolidation!R3C5,consolidation!R3C9,consolidation!R3C13)"
ActiveChart.Location Where:=xlLocationAsNewSheet
With ActiveChart
.HasTitle = False
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = False
End With
ActiveChart.HasLegend = False
ActiveChart.ApplyDataLabels Type:=xlDataLabelsShowNone, LegendKey:=False
ActiveChart.HasDataTable = True
ActiveChart.DataTable.ShowLegendKey = True
End Sub
Partager