Jump to content
Software FX Community

Re: Scatter Chart Question

User (Legacy)

Recommended Posts

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 =


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


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


> 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


Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...