Automatically create trend table using symbols

C

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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting cells from a table 6
Conditional SUM for Budget, Actuals, & Variance YTD columns 0
Automatically running VBA code in Project 0
Pivot Table Set Up 2
Problem creating a logarithmic trend line 2
VBA to create series of workbooks need to add code to skip creating areport if no lines meet criteri 2
SUMIF using cells with commas in 1
Create a drop down list which automatically inputs linked informat 3

Top