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 lt;5%
variance to budget; a second symbol for 6-10% variance to budget, and a
third symbol for gt;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: www.excelforum.com/member.php...oamp;userid=31912
View this thread: www.excelforum.com/showthread...hreadid=516438Assuming 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 gt;, cmbl.23rj2m_says...
gt;
gt; Good evening,
gt;
gt; A client wants to create a table of data for a PowerPoint presentation,
gt; where tolerance to budget is indicated by a symbol: one symbol for lt;5%
gt; variance to budget; a second symbol for 6-10% variance to budget, and a
gt; third symbol for gt;10% variance to budget. Of course, it could be done
gt; manually but he wants to automatically insert a symbol for each of the
gt; three ranges.
gt;
gt; Is there an easy way to do this?
gt;
gt; thanks,
gt;
gt; Christine
gt;
gt;
gt; --
gt; cmbl
gt; ------------------------------------------------------------------------
gt; cmbl's Profile: www.excelforum.com/member.php...oamp;userid=31912
gt; View this thread: www.excelforum.com/showthread...hreadid=516438
gt;
gt;
- May 27 Tue 2008 20:44
Automatically create trend table using symbols
close
全站熱搜
留言列表
發表留言
留言列表

