AW: Meilensteintrendanalyse Diagramm Formatierung
11.08.2015 14:34:50
Raphael
Danke Karin!!!
Ich habe es hinbekommen ;)
Function Diagramm_1_erstellen()
'Tabelle erstellen
Sheets("Tabelle1").Select
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=Sheets("Datentabelle_KW").Range("B10:BB43")
'Achsen anpassen
'für KWs max=52
ActiveChart.Axes(xlValue).MaximumScale = 52
ActiveChart.Axes(xlValue).MinimumScale = 0
ActiveChart.Axes(xlValue).MajorUnit = 1
ActiveChart.Axes(xlValue).Select
Selection.TickLabels.NumberFormat = "KW ##"
Selection.TickLabels.NumberFormat = "KW ##"
With ActiveChart.Axes(xlCategory).Select
Selection.TickLabels.NumberFormat = "KW ##"
Selection.TickLabels.NumberFormat = "KW ##"
End With
s = 2
k = 11
z = 1
Do While Not s = 0
If Cells(k, 2) = "" Then
s = 0
Else
'Formatierung Datenreihe
End If
k = k + 1
Loop
End Function
Function Diagramm()
Dim lngReihe As Long
With ActiveSheet.ChartObjects("Diagramm 31").Chart
For lngReihe = 1 To .SeriesCollection.Count
With .SeriesCollection(lngReihe)
.MarkerStyle = 2
.MarkerSize = 10
End With
Next lngReihe
End With
End Function