changing color palette of a microsoft graph per vba

[Franz]

Hello,
I have to change the colors of series in a microsoft graph
per VBA. The colors are user definied colors (the colors
are saved ina database). There is no problem with setting
the color if the color is in the color palette.
But in case the color is not in the palette I need to add
the color to the color palette, but how can this be done?
The graph is placed in a power-point presentation.
I'm using graph 9 und PowerPoint 2002.

Thanks in advance
Franz

 

[Cindy Meister -WordMVP-]

Hi Franz,

I'm afraid MS Graph doesn't support this. You'd need to build
Excel graphs, instead, in order to get access to color
palettes. The Powerpoint folks (Brian Reilly, especially)
know more about this, but hang out primarily in their
newsgroup.

I have to change the colors of series in a microsoft graph
per VBA. The colors are user definied colors (the colors
are saved ina database). There is no problem with setting
the color if the color is in the color palette.
But in case the color is not in the palette I need to add
the color to the color palette, but how can this be done?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[Cindy Meister -WordMVP-]

Hi Franz,

I couldn't find the MSDN managed PowerPoint-NewsGroup!? I
really need an answer. It can't be true, that there is no
way to modify the color-palette.

The powerpoint group probably isn't "maganed MSDN", but it's
a public group on the microsoft msnews server. In my
newsreader, I see it as public.powerpoint

And there really is no interface to the color palette over
MS Graph. Just like you can't do anything with any Shapes
(text boxes). The object model doesn't expose it.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Cindy Meister -WordMVP-]

Hallo Petra

mein Englisch ist ein bißchen schroff. Ich bin etwas
gefrustet, da ich seit Tagen versuche die Farben im Graph
zu setzen und einfach nicht weiter komme. Ich möchte nicht
den Excel-Graph in der Präsentation aufnehmen.

Mit "schroff" habe ich kein Problem Man hat vor allem
sein Problem zuvorderst, wenn man in Newsgruppen um Hilfe
sucht. Aber leider ändert weder Ton noch Sprache nichts an
der Tatsache, dass MS Graph keinen Zugang zur Farbenpalette
bietet. Wie gesagt, Du solltest in der englisch-sprachigen
Powerpoint Gruppe fragen. Brian Reilly hat das Thema
gründlich durchforstet (wir reden immer darüber, wenn wir
einander treffen - auch vor zwei Wochen), und hat auch einige
Umwege ausgearbeitet, um die "Belastung" durch das Excel-Ding
möglichst gering zu halten.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail