How to change the color of a graphic´s bar ?

[Jerry Adriane Gonçalves]

Hi,

In my presentation I have some slides containing graphics. The data sheet
for each graphic is linked to an excel range.

I would like to change the graphic bar´s color according value shown (e.g:
if value < 50 the bar must be red, if >= 50 the bar must be green).

Is there some way to do this using macro (vba) ? How can I do this ?

Thanks in advance.

Jerry

 

[Glen Millar]

Jerry,

I'm not sure I totally follow, but it sounds like something that Martin
Conradi posted a solution to. it is a commercial addin of which there is a
trial version:

www.showcasesolutions.net/SPProductsPage.htm - it is called Carte Blanche.

It is for maps, but you could link a graph made out of autoshapes to an
external data sheet. Worth a look, anyway.


--
Regards,

Glen Millar
Microsoft PPT MVP
http://www.powerpointworkbench.com/
Please tell us your ppt version, and get back to us here
Remove spaces from signature