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

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


"Jerry Adriane Gonçalves" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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
>
>
>