1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Sub test()
Dim Plage As Range
Dim Graph As New ClsGraph
Set Plage = Range("A1:C12")
Graph.Delete Sheets("Graph1"), "Graph1"
Graph.Nouveau Sheets("Graph1"), "Graph1"
Graph.Style ExlConeCol
Graph.Source Plage, xlRows
Graph.SeriesCollection "=Recap!$C$64:$CP$64"
Graph.SeriesCollection_Caption "Mois", msoElementPrimaryCategoryAxisTitleAdjacentToAxis
Graph.SeriesCollection_Caption "ETPs", msoElementPrimaryValueAxisTitleRotated
Graph.SeriesCollection_Caption "Plan de charge Technique groupé par famille", msoElementChartTitleAboveChart
Graph.Position 0, 0
Graph.Taille 550, 700
Graph.SeriesCollection_Visible
Graph.SaveAs_Image Sheets("Graph1"), "Graph1", ActiveWorkbook.Path & "\" & "graphe.gif"
End Sub |
Partager