| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reference graphic images in formulas rather than text?
I'm trying to create an automated seating chart. I'd like to use the
"vlookup" function to display the student's picture in the appropriate location on the chart just as I'm using "vlookup" to display the student's name. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I reference graphic images in formulas rather than text?
mosik
Check out John McGimpsey's site... http://www.mcgimpsey.com/excel/lookuppics.html Gord Dibben MS Excel MVP On Mon, 14 Aug 2006 21:36:32 -0700, rnosik wrote: I'm trying to create an automated seating chart. I'd like to use the "vlookup" function to display the student's picture in the appropriate location on the chart just as I'm using "vlookup" to display the student's name. Gord Dibben MS Excel MVP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I reference graphic images in formulas rather than text
I am trying to perform a similar task and am a VB novice. I can't get this
to work for my situation. Can you provide some extra info? Thanks, "Gord Dibben" wrote: mosik Check out John McGimpsey's site... http://www.mcgimpsey.com/excel/lookuppics.html Gord Dibben MS Excel MVP On Mon, 14 Aug 2006 21:36:32 -0700, rnosik wrote: I'm trying to create an automated seating chart. I'd like to use the "vlookup" function to display the student's picture in the appropriate location on the chart just as I'm using "vlookup" to display the student's name. Gord Dibben MS Excel MVP |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I reference graphic images in formulas rather than text
Daigle wrote: I am trying to perform a similar task and am a VB novice. I can't get this to work for my situation. Can you provide some extra info? Thanks, Hi Daigle, Can you gives some detail about your situation? Ken Johnson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I reference graphic images in formulas rather than text
I am trying to create a table that shows images (shaded pies: no
shade,1/4,1/2,3/4,full shade) to represent progress on measures hitting targets. We have these five images that would be referenced in a table with multiple columns and multiple rows. Thanks! "Ken Johnson" wrote: Daigle wrote: I am trying to perform a similar task and am a VB novice. I can't get this to work for my situation. Can you provide some extra info? Thanks, Hi Daigle, Can you gives some detail about your situation? Ken Johnson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I reference graphic images in formulas rather than text
Daigle wrote: I am trying to create a table that shows images (shaded pies: no shade,1/4,1/2,3/4,full shade) to represent progress on measures hitting targets. We have these five images that would be referenced in a table with multiple columns and multiple rows. Thanks! Hi Daigles, Is my interpretation of your situation correct? You want each cell in your table of multiple rows and columns to be able to show one of five mini piechart pictures, where the one that is displayed depends on the value in the same cell. Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference date as text | Excel Worksheet Functions | |||
| Reference Formulas | Excel Worksheet Functions | |||
| need a refresher: text boxes on charts that use relational formulas? | Charts and Charting in Excel | |||
| Coping text using Formulas - | Excel Discussion (Misc queries) | |||
| Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
Hybrid Mode
