Great answer,
Thanks
Robert
>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