Insert Shape into Scatter Chart

[vthokienj]

I am looking to create a chart of type xlXYScatter and insert a shape (e.g. triangle) at each point, then color each shape using RGB. I have yet to find out how to do this. Is this possible in VBA?
Any guidance would be appreciated.

I am only at the point where I have the chart defined and I iterate through each point:

set thechart = Sheets("mysheet").ChartObjects("mychartname")
v = thechart.Chart.SeriesCollections(1).Values
numPoints = UBound(v,1)

for x = 1 to numPoints

next x

Thanks

 

[pgc01]

Hi

Can you just use a marker with the triangle shape?
It would be a simple solution and you'd just need to change the coulours of the markers.

You can do a simple test. Select one marker, change it to triangle, change its size and its colour and see the result.
If you record a macro while doing it, you'll have some code to get you started.

 

[vthokienj]

Thank you for the solution. This is exactly what my program needed.

 

[pgc01]

I'm glad it helped. Thanks for the feedback.