Programmatically Create ColorIndex RGB values MSGraph VBA (PPT 200

T

Thom

Hi Everyone.

I was wondering if it is possible to change the RGB Values of the MSGraph
ColorIndex using code rather than having to manually enter the RGB values,
each time a new chart is created?

Many thanks

Thom
 
M

Mike Clayton

Hi Thom,

I tried to do this myself a while ago. The documentation at
http://msdn.microsoft.com/library/d...en-us/vbagr11/html/grproColors_HV03082363.asp
suggests you should be able to modify the palette but it didn't seem to work
for me - the value at every color index was 0 and setting it didn't change
the value.

I was trying to do it inside PowerPoint and in the end I got round it by
silently opening a ppt file that had a manually pre-formatted chart in it and
automating copy&paste into the user's presentation. That doesn't help for
existing charts but it'll do the job if you're just inserting a new one from
scratch.

I'd be interested to know if you find a proper solution.

Regards,

Mike
 
T

Thom

Hi Mike. Thanks for this.

The silent ppt was my backup option that i was trying to avoid, but after
much hunting, it looks like thats what i'm going to have to do.

Take care

Thom
 
Top