Axis, calculate the increment property
Posted: Fri Mar 31, 2006 4:56 am
Hello,
I want to calculate increment in the following way:
but TChart show labels as as if Increment property is equal zero.
But if to set the breakpoint on line 'min = .Left.Minimum' (in VBA editor) when the Increment property is calculating correctly.
What is it and what it would be necessary to make that the increment was calculated always ?
Best regards, Rustam.
I want to calculate increment in the following way:
Code: Select all
With sourceChart.Axis
Dim min, max As Double
.Left.Visible = True
.Left.Automatic = True
min = .Left.Minimum
max = .Left.Maximum
.Left.Increment = (max - min) / 5
End With
But if to set the breakpoint on line 'min = .Left.Minimum' (in VBA editor) when the Increment property is calculating correctly.
What is it and what it would be necessary to make that the increment was calculated always ?
Best regards, Rustam.