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