Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Manipulating an Excel Graph
Message
De
12/10/1998 10:39:49
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Manipulating an Excel Graph
Divers
Thread ID:
00145901
Message ID:
00145901
Vues:
64
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform