I'm not sure what you are trying to do but I used Google and found this link. It talks about why you can't do it and then someone pops in with what they say works.

I'm just guessing because I don't do much Excel formatting.

http://www.excelforum.com/excel-char...x-y-chart.html