Using VBA macro to format points in scatter chart (by series)

Hello,
I would appreciate any help you can give.
I have a scatter chart, excel 2013, where I have assigned code to give the
points labels. I have 9 series. I would like to assign a specific marker style for
each series (each point in series 1 is a blue circle, each point in series 2 is
a blue triangle)...

On Microsoft's website I found code such as:
Charts("Chart1").SeriesCollection(1) _
.MarkerStyle = xlMarkerStyleCircle

but I do not know where to put it inside the code I am already using (I do not really know
VBA and just copied/pasted this code.

Could you tell me where to insert this code?

*Also, if you could help me make the labels be in the center of the marker, that would be
awesome.

Thank you

Please Login or Register  to view this content.

http://www.filedropper.com/exampleversionriskmapping example file without code

Cross post
http://www.ozgrid.com/forum/showthread.php?t=198365