Re: Scatter Chart Question

[User (Legacy)]

Here is an Access example where each series has it's own marker shape. 

    'set series and points 

    nSeries = rsCmkt.RecordCount  'this was ok, trying for one more series 

    nPoints = 1 

    'open data channel 

    objChart1.OpenDataEx COD_VALUES, nSeries, nPoints 

    objChart1.OpenDataEx COD_XVALUES, nSeries, nPoints 

    j = 0   'this is a one series chart, xy plot 

    Do Until rsCmkt.EOF ' Begin loop for each series/row. 

        objChart1.Series(j).MarkerShape = j + 1    'each series gets it's 

own shape 

        objChart1.Series(j).PointLabels = False 

        objChart1.Series(j).Legend = rsCmkt.Fields(0).Value 'first column = 

Labels 

        If Not IsNull(rsCmkt.Fields(0).Value) Then 

            objChart1.XValueEx(j, 0) = rsCmkt.Fields(1).Value 

            objChart1.ValueEx(j, 0) = rsCmkt.Fields(2).Value 

        End If 

        rsCmkt.MoveNext ' Locate next record. 

        j = j + 1 

    Loop ' End of loop. 

    'close data channel 

    objChart1.CloseData COD_VALUES 

    objChart1.CloseData COD_XVALUES 

Steve 

Lisa Jahrsdoerfer <lisaj@mobiusg.com> wrote in message 

news:DE0379D14694D211B4CE00609770710D0444DB@sftfx-221.wamnet.net... 

> Hi, 

> 

> Is there a way to create one Scatter Series with multiple points and then 

> set each point to a different marker? 

> 

> Thanks, 

> Lisa Jahrsdoerfer 

>