The ColorIndex -4105 indicates that the series is set to Automatic (just as -4142 indicates None). To grab the actual color of the interior, and set the border to it's value use the
Color property rather than the
ColorIndex property:
lnthisborder = .seriescollection(1).interior.<b>color</b>
.seriescollection(1).interior.colorindex = xlNone
.seriescollection(1).border.<b>color</b> = lnthisborder
>I want to change the bars on a graph to just be the outline. I can set the area to none but how do I retreive the color the area was so that I can set the "border.colorindex" to that color.
>I tried:
>with ox.charts(1)
> .hastitle = .T.
> .haslegend = .T.
> .ChartTitle.caption = 'This is chart title'
> .plotby = 2
> .walls.Interior.ColorIndex = xlNone
> lnthisborder = .seriescollection(1).interior.colorindex
> .seriescollection(1).interior.colorindex = xlNone
> .seriescollection(1).border.colorindex = lnthisborder
>endwith
>but lnthisborder is always -4105
>
>TIA
>Robert
kenweber
GCom2 Solutions
Microsoft Certified Professional