Change series colour in 3-D chart on report.

[Daveo]

Hi there,

I have a 3-d chart that I want to set the colour of a series on. The
problem is, the colour I want is not one of the default ones
available. I assume I would then have to set the colours I want using
VB on the On Format event or something, but was wondering how to refer
to the chart and then the particular series and then the colour
property.

Thanks in advance for any help.

Cheers - David

 

[Guest]

first go to VBA and add reference to graph object, if
you do not already have one. this helps you find the names
of methods and properties (you can remove the reference
later if you code carefully).

chart is an object in a control on the report. identify the control,
then refer to it's source object, then use the object names
and methods.

 

[i_takeuti]

Hi there,

I have a 3-d chart that I want to set the colour of a series on. The
problem is, the colour I want is not one of the default ones
available. I assume I would then have to set the colours I want using
VB on the On Format event or something, but was wondering how to refer
to the chart and then the particular series and then the colour
property.

Thanks in advance for any help.

Cheers - David