Automatically create trend table using symbols

[cmbl]

Good evening,

A client wants to create a table of data for a PowerPoint presentation, where tolerance to budget is indicated by a symbol: one symbol for <5% variance to budget; a second symbol for 6-10% variance to budget, and a third symbol for >10% variance to budget. Of course, it could be done manually but he wants to automatically insert a symbol for each of the three ranges.

Is there an easy way to do this?

thanks,

Christine

[Tushar Mehta]

Assuming it is a table created with Excel and inserted into PowerPoint...

If the symbols of interest are part of some font, a simple IF statement
should suffice. If they are image files, you will have to use VBA code.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>, cmbl.23rj2m_
[email protected] says...
>
> Good evening,
>
> A client wants to create a table of data for a PowerPoint presentation,
> where tolerance to budget is indicated by a symbol: one symbol for <5%
> variance to budget; a second symbol for 6-10% variance to budget, and a
> third symbol for >10% variance to budget. Of course, it could be done
> manually but he wants to automatically insert a symbol for each of the
> three ranges.
>
> Is there an easy way to do this?
>
> thanks,
>
> Christine
>
>
> --
> cmbl
> ------------------------------------------------------------------------
> cmbl's Profile: http://www.excelforum.com/member.php...o&userid=31912
> View this thread: http://www.excelforum.com/showthread...hreadid=516438
>
>