Change color of my graph

[Guest]

Hello. I have make graphs of occupation of the grounds by cities.a city does
not have all the events, the colors of the graphs changes. I would like to
have colors fix. I would like to do it with VBA. Is this possible?

 

[Guest]

Hi Alfred

Yes, the Microsoft Graph Object Library allows you to create and do just
about anything to graphs through VBA. By linking in with other MS Office
objects you can, for example, use Access to manipulate graphs in Word and
Excel.

If you set a reference to the MS Graph # Object Library you can see all the
Classes etc. in Object Browser (F2 from any module).

Its much to involved to cover here - I suggest you buy a book that features
MS Graph manipulation using VBA.

Cheers.

BW