Using Microsoft Excel Chart object in VB6

  • Thread starter Thread starter fizbim
  • Start date Start date
F

fizbim

I have added a "Microsoft Excel Chart" object to a form, then sized th
chart to fit the form. The chart has been modified to show the prope
axis labels, scaling, etc. In effect, creating the template.

The Excel Chart has a "Chart" tab and a "Sheet1" tab where the Sheet
tab is the actual worksheet for the chart plot data. My problem i
filling in "THIS" worksheet with data from my array. I cannot find an
object reference to an Excel worksheet in my project. The Excel Char
object only has parameters for height, width, top, bottom locations
etc.

As a stab in the dark, I tried this code segment to attempt to fill th
worksheet with no success.

For r = 0 To 1400
Worksheets("Sheet1").Cells(r + 1, 1) = r
Worksheets("Sheet1").Cells(r + 1, 2) = TripData(1, r)
Next r

How do I access the worksheet portion of an Excel Chart object that ha
been added to a form ?

Thanks,
Fi
 
Back
Top