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.
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.
Last edited by luv2glyd; 06-06-2010 at 10:01 AM.
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:
Set thechart1 = Sheet53.ChartObjects("Chart 6") 'make series transparent (0 for non transparent, 1 for transparent, and anywhere in between for various degrees of transparency): thechart1.Chart.SeriesCollection(5).Format.Line.Transparency = 0 'change color of the line: thechart1.Chart.SeriesCollection(5).Format.Line.ForeColor.SchemeColor = 4
Last edited by luv2glyd; 06-06-2010 at 10:01 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks