how to change line color and transparancy in XY scatter chart

I have a XY scatter line chart named "chart 7" and a series named "Close". How can I set the transparancy to be 100% using VB?

Also, how would I change the color of the line to be dark blue for example?

Thank you.

See previous thread
http://www.excelforum.com/excel-char...ect-issue.html


Please update your profile to state Excel/Office version.

That works! Thank you.

I did a variation of that post response and some others:

Please Login or Register  to view this content.