VBA coding Sctaeer chart - xlMarkerStyle

**Prue** · 11-12-2012, 06:29 AM

Hello,

A few months back, I was working on a scatter chart and the coding behind it – and this forum really helped me.
Lately I have been working on this spread sheet, trying to improve it and I am facing a few difficulties.

Previously, I was working on matching data to specific markers and using a coding to do so. For each point on the scatter chart you could choose a "type" from the dropdown menu and each "Type" option had a shape appointed to it. Depending on the "type" option selected the specific shape would appear on the chart.

I have added 2 additional “Types” to the drop down menu and therefore was seeking two new markers and adding them to the coding.
Is there any additional xlMarkerStyle that I could use – I tried “Automatic” and “Picture” but when I save and try it on the drop-down menu no markers appear on the scatter chart… the problem might be just me not editing the coding properly…

Please let me know if you have a solution to my problem,

Thank you very much in advance,
Prue

**Andy Pope** · 11-12-2012, 06:55 AM

You have exhausted the built-in marker types.
You can use shapes as markers. I have added 2 shapes, star and cloud, plus the additional code to format and paste the shape to the marker.

**Prue** · 11-12-2012, 10:19 AM

Thank you very much Andy for your help and responsiveness!
This great. Is there a specific way to add a marker if I went through the list predifines ones. I just map your coding?

Very best,
Prudence

**Andy Pope** · 11-12-2012, 10:22 AM

to add new custom ones insert the shape on the sheet and change it's name.
Use the new name to reference that shape in the code as per the 2 extra items I have already included.