Dear allMisserableProgrammerWhoLoseTooMuchSleepAndDrinkAlotOfJava :O,

I having in displaying XY chart using MSChart. When I try to display this
chart the
control only display the chart line and I lost the label for x and y axis.
But If I put x axis as 1,2,3
and so on, the control display the chart with all x and y label but the
y range is very small.

I compare the chart with excell and the plot seems okay in excel but only
in MsChart that
the control seems confuse in displaying the chart. Is there any bugs(except
that 15 digits
bugs) that restrict the use of MsChart or what do I do wrong in the codes
? my other question is
there a way to strech out the y axis so the y will be longer ?


Thankx for all help or hint,
AnotherMisserableProgrammerWhoLoseTooMuchSleepAndDrinkAlotOfJava,


Joni

here are my sample codes to display the chart:

Option Explicit

Private Sub Form_Load()
Dim c As MSChart
Dim aV(10) As Double
Dim count As Integer
Dim x As Integer, y As Integer
Set c = MSChart1


With c
.chartType = VtChChartType2dXY
.ColumnCount = 2
.RowCount = 8

'X Axis
.Column = 1
.Row = 1
.Data = 1

.Row = 2
.Data = 12.28571429

.Row = 3
.Data = 23.57142857

.Row = 4
.Data = 34.85714286

.Row = 5
.Data = 46.14285714

.Row = 6
.Data = 57.42857143

.Row = 7
.Data = 68.71428571

.Row = 8
.Data = 80

'Y Axis
.Column = 2
.Row = 1
.Data = 1.052584831

.Row = 2
.Data = 0.702571577

.Row = 3
.Data = 0.579543159

.Row = 4
.Data = 0.527528955

.Row = 5
.Data = 0.498522344

.Row = 6
.Data = 0.479812572

.Row = 7
.Data = 0.466619638

.Row = 8
.Data = 0.45677625



With .Plot.SeriesCollection.Item(1)
.SeriesMarker.Auto = False
.DataPoints.Item(-1).Marker.Visible = True
.DataPoints.Item(-1).Marker.Size = 140
.DataPoints.Item(-1).Marker.Style = VtMarkerStyle3dBall
.DataPoints.Item(-1).Marker.FillColor.Automatic = False
.DataPoints.Item(-1).Marker.FillColor.Set 0, 0, 255

End With


End With

End Sub