General information
Title:
Manipulating an Excel Graph
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only