Re: MS Graph colors

Tech-Archive recommends: Fix windows errors by optimizing your registry

In article <Michael.Reese.1zf9ly@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>, Michael Reese
wrote:
> I want to change the color index of a MS Graph object, which I expose in
> an Access application. I can either do it programmatically (preferred)
> or at design time.

You can change the Index, which points to one of the 56 MSGraph colors, but you
can't change the value of the color it points to.


>
> I can change the ColorIndex property of an Excel chart
> programmatically, using the workbook Colors(Index) property, with Index
> indicating the ColorIndex value to change. The Index range, of course,
> is 1 to 56, and to change the Index in Excel object wkbBook1, as
> follows:
>
> wkbBook1.Colors(44) = vbYellow
>
> ...changes the ColorIndex 44 to Yellow. Any color value can be used.
>
> However, I cannot do the same code for the MS Graph object. I suspect
> I'm looking at a higher level object to access. I would like to know
> which object controls the ColorIndex property for the MS Graph object,
> and if it can't be done programmatically, how can I set it at design
> time? I don't mind API or even registry changes, but I can't seem to
> find the ColorIndex anywhere.
>
> Thanks for your help.
>

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

.