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

Click here to load this message in the networking platform