Color problem
Have you tried
shLI.Line.ForeColor.SchemeColor =
ActiveChart.SeriesCollection(i).Border.Color
--
HTH
RP
(remove nothere from the email address if mailing direct)
"ojv" wrote in message
...
I am trying to set the color on a shape object to the same color as the
border color for a series object. I want to execute a statement akin to:
shLI.Line.ForeColor.SchemeColor =
ActiveChart.SeriesCollection(i).Border.ColorIndex
I know the above code fails but how can I translate the Border.ColorIndex
to
an identical color permitting setting of SchemeColor? Any help
appreciated.
|