code fuer DIAGRAMMFORMATIERUNG kuerzen
29.03.2006 23:07:38
th.heinrich
bekomme nicht mal das select weg :-( gibts sonst noch was zu kuerzen.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Application.ScreenUpdating = False
Sheets("Diagramm1").Select
With ActiveChart.Axes(xlValue)
'.Axes (xlValue)
.MinimumScale = Sheets("Auswertung").Range("L1").Value - 5
.MaximumScale = Sheets("Auswertung").Range("J1").Value + 5
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
.Crosses = xlCustom
.CrossesAt = 0
.ReversePlotOrder = False
.ScaleType = xlLinear
End With
With ActiveChart.Axes(xlCategory)
'.Axes (xlValue)
.MinimumScale = Sheets("Auswertung").Range("P1").Value - 0.5
.MaximumScale = Sheets("Auswertung").Range("N1").Value + 0.5
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
.Crosses = xlCustom
.CrossesAt = Sheets("Auswertung").Range("P1").Value - 0.5
.ReversePlotOrder = False
.ScaleType = xlLinear
End With
Application.ScreenUpdating = True
End Sub
vielen dank fuer hilfe
gruss thomas