VBA to change label, marker style and colour

Firstly, hello everyone, let me introduce myself.

My name is Rajoli and I'm a new member.

I have a unique problem in which the code works with no problems in Excel 2007 and sort of works in Excel 2010.
If I choose to have marker style to be X or star or plus, it works fine in Excel 2007.
In Excel 2010, X or star or plus are shown as a square.

Here is the code and data:

Symbol Color
X Y Name Code Code
78% 55% Alpha 4 1
77% 80% Bravo 5 53
66% 69% Charlie 9 11
11% 67% Delta 1 9
11% 52% Echo 2 46
65% 13% FoxTrot 3 7
56% 32% Golf 7 6


' Copyright (c) 2009 Clear Lines Consulting LLC. All rights reserved.
' http://www.clear-lines.com
' Licensed under the Microsoft Public License (Ms-PL):
' see http://www.microsoft.com/opensource/licenses.mspx

Please Login or Register  to view this content.