Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Manipulating an Excel Graph
Message
 
To
12/10/1998 10:39:49
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00145901
Message ID:
00149496
Views:
22
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

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform