Change the line color in a graph
I'm trying to change the line color of a line in an xyplot.
should work according to the help docs, but it does nothing. I get the color Excel assigned.mySeries.Format.Line.ForeColor.RGB = RGB(100, 150, 220)
Am I beating my head against a wall, or is this another (e.g. line cap) "you can't get there from here" situation.
Last edited by Paul; 12-20-2011 at 12:50 AM. Reason: Added code tags for new user. Please do so yourself in the future.
What if you change
tomySeries.Format.Line.ForeColor.RGB = RGB(100, 150, 220)
Would that work?mySeries.Format.Line.ForeColor.ColorIndex = 17
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks