set polar chart axes maximum value
Posted: Mon Feb 16, 2009 1:13 am
I am updating a polar chart with polarBar series realtime with two points (the origin and the value and angle). I know the maximum value that can be reached on a given polar chart and like to set the axis maximum to that value so that the polar chart doesn't update these values dynamically. I tried the following, but the chart still dynamically changes the max. value of the axes based on the realtime value ( though the realtime value is less than the maximum set value).
The code i am using to set the max is:
Please suggest something.
The code i am using to set the max is:
Code: Select all
With MyPolarChart
.Axes.Left.Maximum = 1000
.Axes.Bottom.Maximum = 1000
.Axes.Right.Maximum = 1000
.Axes.Top.Maximum = 1000
End With