Setting a line color in MS GRAPH from VB

D

DAACKM

Can anyone explain how to programatically set the color of a line in a MS
Graph line or scatter chart. I can't seem to find the proper property.
Thanks.
 
A

Andy Pope

Hi,

Some thing like this. Obviously changing the shape and series indexes to
suit.

With ActivePresentation.Slides(1).Shapes(3)
With .OLEFormat.Object.Application
.chart.seriescollection(1).Border.colorindex = 3 ' red
.Update
End With
End With

You can use RGB Values but like Excel this will be mapped to the nearest
palette colour.

.chart.seriescollection(1).Border.Color = RGB(0, 255, 0) ' green

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Changing row background from external program 0
How to make the shading look uniform around a double spaced line in MS Word? 0
Printing from Word my Inserted Pictures colors are dull and lack color 0
Getting the graph style I want 4
Match table shading (color) to Visio color/Transparency 1
Graph Line Width ? 1
Need help modifying code 0

Top