Help for MS Graph Code 1

[georgesOne]

Hi everybody,

not sure if I am in the correct forum.
My Access database produces a monthly powerpoint presentation. I want to manipulate the presentation details (MS Graph).
I can change the color of the column data series collection in a column chart with the code snippet...

For m = 1 To oGraph.SeriesCollection.Count
With oGraph.SeriesCollection(m)
.Interior.Color = DLookup("Color", "ztbl_Tools1", "Tool = '" & oDataSheet.Cells(m + 1, 1) & "'")
End With
Next m

...but I would like to apply some fill effects to the color of the columns (which is easily made manually).
Any tip how to achieve this?

Thanks a lot, Georges

 

[SkipVought]

Have you tried recording what you want to do?

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[georgesOne]

SkipVought,

thanks for the tip...
I worked in Acces/Powerpoint and the recording did not work.
I now tried Excel and I think I can get the information I need.

Regards, Georges

 

[georgesOne]

Great tip...
Everything is done!
Thanks a lot.

Regards, Georges