Give points for each data series in scatter chart a color, shape, and label,+ auto update

Thank you for any help you can provide.

1st, if necessary, I am fine with assigning a macro to accomplish this (if you can help with the macro code as I cannot code), as long as all users will be able to use this file. I would not be able to have users install an add-in or program.

I am running Office 2013 and have made a scatter chart with 9 series. On the leftmost column is what I use for the label for each point, then y axis, and X axis is taken from the series column.

http://imgur.com/V28hoo6 (the labels are in Japanese but I am a native English speaker - please just take them to be labels)
http://imgur.com/1h8qmnV

The series info is in a table. I want it to be where for each series I can assign a specific shape, color, and data label. It needs to update automatically so that I can put more entries in the table, and new points show up. The shape and color should be the same for each point in each series. (Series 1: all points blue squares. Series 2: all points yellow squares..) I am able to select a series point and add that information. It seems to apply the shape and color to the points already on the chart. However, if I later add info for another entry in the table, the color and shape are lost when a new point shows on the chart. This also happens for the data label. If I delete all the data points for a series, all the color, shape, and data label information disappears. If I then add a new point for the series, that color, shape, and data label info does not show up.

How can I get this set up to retain the color, shape, and data label information so that users can enter and delete information and new data points show up formatted correctly?
Thank you

I am attaching a sample version now.
Thank you for any help - my deadline is approaching soon and I am unable to solve this.

By the way, I can click on a label outline near the point, and put in label options "value from cells"
=map!$A$5:$A$205 which puts a label on the series point. However, if I delete the information for that specific series point later, titles go away. Also often times new series points do not automatically have that title (or shape, or color).

Thank you

Update: Now I am using a macro as I got it to work for adding labels.
I used a sample online, so the names are like "film series" and so on, but it works
in my file.
2 things I would like the macro to do, now:
1- have the label be in the center of the marker, not to the right
2- (bigger part) - format the series markers. I have 9 series - I would like the series,
by column, to be:
(All: size 15)
column d: blue, circle
e orange, circle
f yellow, circle
g blue, triangle
h orange, triangle
i yellow, triangle
j blue, square
k orange, square
l yellow, square

Please Login or Register  to view this content.