Color problem
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.
|