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 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124
| Sub graphique2()
'
' graphique2 Macro
'
'
Range("D25").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.Shapes.AddChart2(201, xlColumnClustered).Select
ActiveChart.SetSourceData Source:=Range("CF_out!$D$25:$R$40")
ActiveChart.FullSeriesCollection(1).ChartType = xlColumnClustered
ActiveChart.FullSeriesCollection(1).AxisGroup = 1
ActiveChart.FullSeriesCollection(2).ChartType = xlColumnClustered
ActiveChart.FullSeriesCollection(2).AxisGroup = 1
ActiveChart.FullSeriesCollection(3).ChartType = xlColumnClustered
ActiveChart.FullSeriesCollection(3).AxisGroup = 1
ActiveChart.FullSeriesCollection(4).ChartType = xlColumnClustered
ActiveChart.FullSeriesCollection(4).AxisGroup = 1
ActiveChart.FullSeriesCollection(5).ChartType = xlColumnClustered
ActiveChart.FullSeriesCollection(5).AxisGroup = 1
ActiveChart.FullSeriesCollection(6).ChartType = xlColumnClustered
ActiveChart.FullSeriesCollection(6).AxisGroup = 1
ActiveChart.FullSeriesCollection(7).ChartType = xlColumnClustered
ActiveChart.FullSeriesCollection(7).AxisGroup = 1
ActiveChart.FullSeriesCollection(8).ChartType = xlLine
ActiveChart.FullSeriesCollection(8).AxisGroup = 1
ActiveChart.FullSeriesCollection(9).ChartType = xlLine
ActiveChart.FullSeriesCollection(9).AxisGroup = 1
ActiveChart.FullSeriesCollection(10).ChartType = xlLine
ActiveChart.FullSeriesCollection(10).AxisGroup = 1
ActiveChart.FullSeriesCollection(11).ChartType = xlLine
ActiveChart.FullSeriesCollection(11).AxisGroup = 1
ActiveChart.FullSeriesCollection(12).ChartType = xlLine
ActiveChart.FullSeriesCollection(12).AxisGroup = 1
ActiveChart.FullSeriesCollection(13).ChartType = xlLine
ActiveChart.FullSeriesCollection(13).AxisGroup = 1
ActiveChart.FullSeriesCollection(14).ChartType = xlLine
ActiveChart.FullSeriesCollection(14).AxisGroup = 1
ActiveChart.FullSeriesCollection(1).IsFiltered = True
ActiveChart.FullSeriesCollection(4).IsFiltered = True
ActiveChart.FullSeriesCollection(5).IsFiltered = True
ActiveChart.FullSeriesCollection(6).IsFiltered = True
ActiveChart.FullSeriesCollection(7).IsFiltered = True
ActiveChart.FullSeriesCollection(8).IsFiltered = True
ActiveChart.FullSeriesCollection(9).IsFiltered = True
ActiveChart.FullSeriesCollection(10).IsFiltered = True
ActiveChart.FullSeriesCollection(11).IsFiltered = True
ActiveChart.FullSeriesCollection(12).IsFiltered = True
ActiveChart.FullSeriesCollection(13).IsFiltered = True
Range("L9").Select
ActiveSheet.ChartObjects.Activate ("Graphique 5")
ActiveSheet.Shapes("Graphique 5").IncrementLeft -210
ActiveSheet.Shapes("Graphique 5").IncrementTop -168
ActiveSheet.ChartObjects("Graphique 5").Activate
ActiveSheet.Shapes("Graphique 5").ScaleWidth 1.8023810149, msoFalse, _
msoScaleFromTopLeft
ActiveSheet.Shapes("Graphique 5").ScaleHeight 1.4603175124, msoFalse, _
msoScaleFromTopLeft
ActiveSheet.ChartObjects("Graphique 5").Activate
ActiveSheet.ChartObjects("Graphique 5").Activate
ActiveChart.FullSeriesCollection(3).Select
ActiveChart.FullSeriesCollection(2).Select
With Selection.Format.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 80, 80)
.Transparency = 0
.Solid
End With
ActiveChart.FullSeriesCollection(14).Select
With Selection.Format.Fill
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent1
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = 0.400000006
.Transparency = 0
.Solid
End With
With Selection.Format.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent4
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = 0.400000006
.Transparency = 0
End With
With Selection.Format.Line
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 0)
.Transparency = 0
End With
With Selection.Format.Line
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 192, 0)
.Transparency = 0
End With
Range("D12").Select
ActiveSheet.ChartObjects("Graphique 5").Activate
ActiveChart.ChartTitle.Select
ActiveChart.ChartTitle.Text = "Short Terms Liquidity States (betw. W" & TextBox1 & " and W" & TextBox2 & ")"
Selection.Format.TextFrame2.TextRange.Characters.Text = "Short Terms Liquidity States (betw. W" & TextBox1 & " and W" & TextBox2 & ")"
With Selection.Format.TextFrame2.TextRange.Characters(1, 21).ParagraphFormat
.TextDirection = msoTextDirectionLeftToRight
.Alignment = msoAlignCenter
End With
With Selection.Format.TextFrame2.TextRange.Characters(1, 21).Font
.BaselineOffset = 0
.Bold = msoFalse
.NameComplexScript = "+mn-cs"
.NameFarEast = "+mn-ea"
.Fill.Visible = msoTrue
.Fill.ForeColor.RGB = RGB(89, 89, 89)
.Fill.Transparency = 0
.Fill.Solid
.Size = 14
.Italic = msoFalse
.Kerning = 12
.Name = "+mn-lt"
.UnderlineStyle = msoNoUnderline
.Spacing = 0
.Strike = msoNoStrike
End With
Range("E11").Select
End Sub |
Partager