MSChart

MSChart AxtiveX Control

I am looking through MSDN, but I'm not finding a way to set the range of an axis. I am charting percentages in 2D line chart, and when they are all above 95%, why do I need to show 0-100, when 90-100 will give much better resolution.

Any idea on how to set the range?

Here it is

Code:

---

Private Sub Command1_Click()
  ' Set chart type to 2d bar
    Form1.MSChart1.chartType = VtChChartType2dBar

    ' Use manual scale to display y axis (value axis)
    With Form1.MSChart1.Plot.Axis(VtChAxisIdY).ValueScale
    .Auto = False
    .Minimum = -100
    .Maximum = 100
    End With
End Sub

---

DocZaf
{;->

That info is from ms
http://support.microsoft.com/support.../Q189/1/59.ASP

Plot axis value scale, none of which is listed where I was looking.

http://msdn.microsoft.com/library/de...rtObject_P.htm

Thank you very much.