list of properties for objects in class MSGraph.chart.8

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paulv - 15 Mar 2007 13:26 GMT

I am trying to find a list of properties on the objects of an
MSGraph.chart.8. Specifically, I am trying to set the colors of the lines
for the data series in a line graph and I do not know the specific property
name(s) to do this.

Reply to this Message

Ralph - 15 Mar 2007 14:53 GMT

http://msdn2.microsoft.com/en-us/library/aa294274(office.10).aspx

Look at MarkerForegroundColor

> I am trying to find a list of properties on the objects of an
> MSGraph.chart.8. Specifically, I am trying to set the colors of the lines
> for the data series in a line graph and I do not know the specific property
> name(s) to do this.

Reply to this Message

BeWyched - 15 Mar 2007 15:42 GMT

Hi PaulV

Try:

objGraph.SeriesCollection(1).Border.Color = RGB(255, 255, 255)

Change the (1) to suit the line you want to colour. The RGB index is the
standard range from (0, 0, 0) to (255, 255, 255) - e.g (255, 0, 0) is red. If
you don't know the RGB index then 'paint' a text box in Access, steal the
colour reference and use that instead.

Don't be confused with the reference to 'border' - in MSGraph context, a
'line' is a box (insides, surrounded by a border) with no insides !

Cheers.

BW

Reply to this Message