Change series colour in 3-D chart on report.

D

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
 
G

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

i_takeuti

Daveo said:
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
Click to expand...
 
Top