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 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89
| Sub MEF01_Emplacement_Chart()
'Mise en forme des graphiques de la feuille indicateur
Dim xRg As Range
Dim xChart As ChartObject
Dim Nom_Chart As String
Dim L As Integer, C As Integer
Dim Wdth As Double
Indicateurs.Range("C1:l2").UnMerge
Wdth = 10.43
Indicateurs.Range("A:E,G:K,M:Q").ColumnWidth = Wdth
Indicateurs.Range("C1:j2").Merge
Indicateurs.Range("k1:l2").Merge
i = 1
'Graphique 1
Set xChart = Indicateurs.ChartObjects(1)
Nom_Chart = xChart.Name
ActiveSheet.Shapes(Nom_Chart).Line.Visible = msoFalse
ActiveSheet.Shapes(Nom_Chart).Fill.Visible = msoFalse
ActiveSheet.Shapes(Nom_Chart).Line.ForeColor.RGB = RGB(214, 229, 231)
L = val(Mid(Nom_Chart, 2, 1))
C = val(Mid(Nom_Chart, 4, 1))
Set xRg = Indicateurs.Range(cells(L + 2, C), cells(L + 19, C + 4))
xChart.Top = xRg(1).Top
xChart.Left = xRg(1).Left
xChart.Width = xRg.Width
xChart.Height = xRg.Height
'Graphique 2
Set xChart = Indicateurs.ChartObjects(2)
Nom_Chart = xChart.Name
ActiveSheet.Shapes(Nom_Chart).Line.Visible = msoFalse
ActiveSheet.Shapes(Nom_Chart).Fill.Visible = msoFalse
ActiveSheet.Shapes(Nom_Chart).Line.ForeColor.RGB = RGB(214, 229, 231)
L = val(Mid(Nom_Chart, 2, 1))
C = val(Mid(Nom_Chart, 4, 1))
Set xRg = Indicateurs.Range(cells(L + 19, C), cells(L + 30, C + 4))
xChart.Top = xRg(1).Top
xChart.Left = xRg(1).Left
xChart.Width = xRg.Width
xChart.Height = xRg.Height
'Graphique 3 à 10
For i = 3 To 10
Set xChart = Indicateurs.ChartObjects(i)
Nom_Chart = xChart.Name
ActiveSheet.Shapes(Nom_Chart).Line.Visible = msoFalse
ActiveSheet.Shapes(Nom_Chart).Fill.Visible = msoFalse
ActiveSheet.Shapes(Nom_Chart).Line.ForeColor.RGB = RGB(214, 229, 231)
L = val(Mid(Nom_Chart, 2, 1))
C = val(Mid(Nom_Chart, 4, 1))
Set xRg = Indicateurs.Range(cells(L + 2 + (L - 1) * 5, C + (C - 1) * 5), cells(L + 2 + (L - 1) * 5 + 5, C + (C - 1) * 5 + 4))
xChart.Top = xRg(1).Top
xChart.Left = xRg(1).Left
xChart.Width = xRg.Width
xChart.Height = xRg.Height
Next i
'Graphique 11 et 12
For i = 11 To 12
Set xChart = Indicateurs.ChartObjects(i)
Nom_Chart = xChart.Name
ActiveSheet.Shapes(Nom_Chart).Line.Visible = msoFalse
ActiveSheet.Shapes(Nom_Chart).Fill.Visible = msoFalse
' ActiveSheet.Shapes(Nom_Chart).Line.ForeColor.RGB = RGB(214, 229, 231)
L = val(Mid(Nom_Chart, 2, 1))
C = val(Mid(Nom_Chart, 4, 1))
Set xRg = Indicateurs.Range(cells(L + (L - 1) * 5 + (L - 1), C + (C - 1) * 5), cells(L + (L - 1) * 5 + 5 + (L - 1), C + (C - 1) * 5 + 4))
xChart.Top = xRg(1).Top
xChart.Left = xRg(1).Left
xChart.Width = xRg.Width
xChart.Height = xRg.Height
Next i
Call Unselect
End Sub |
Partager