Picture / Image, behind data ????

Hi,

    I have an image question.  In MS Word, you can set up 
a picture to be displayed behind text.  Why can't you do 
this in Excel.  I would love to have certain images behind 
cell data.  Is there a way to do this??????

0
anonymous (74722)
2/9/2004 1:30:53 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
280 Views

Similar Articles

[PageSpeed] 8

Hi Chris
if you want watermarks you may have a look at the following sites:

http://www.xl-logic.com/pages/formulas.html
http://www.rondebruin.nl/files/Watermark.zip

HTH
Frank


Chris wrote:
> Hi,
> 
>     I have an image question.  In MS Word, you can set up
> a picture to be displayed behind text.  Why can't you do
> this in Excel.  I would love to have certain images behind
> cell data.  Is there a way to do this??????

0
frank.kabel (11126)
2/9/2004 1:34:44 PM
Hi Chris, the only way I know is to have a picture 
displayed when you hover over the cell, as follows.

Select cell, right click and insert comment.
Right click on cell cross hatching and select format 
comment.
Color and Lines tab, select fill color drop down arrow.
Select fill effects at the bottom.
Select picture tab and on this box select picture will 
allow you to insert a picture of your choice.
Hope that this helps. I guess it depends on what you are 
trying to achieve...

Regards, Nick.   




>-----Original Message-----
>Hi,
>
>    I have an image question.  In MS Word, you can set 
up 
>a picture to be displayed behind text.  Why can't you do 
>this in Excel.  I would love to have certain images 
behind 
>cell data.  Is there a way to do this??????
>
>.
>
0
anonymous (74722)
2/9/2004 3:24:43 PM
Reply:

Similar Artilces:

Adding additional data to a pivot chart
Hello, I am trying to add a line or some sort of note to a pivot chart and I'm wondering how to do it. I will have multiple items but the note only occurs on one date for each particular item. For example, let's say that I am keeping track of when I buy an item (month and year) and when I sell an item (month and year). I want to add some sort of note automatically to my pivot charts indicating when I put these items on sale (month and year). For example, maybe I put all RC Cars on sale May-01 and all airplanes on sale Oct-05. How can I get the sale date into my pivot chart? I&#...

moving XML data from client to server vice versa
.... The second time I am sending this email ... .... I want a good solution, please. .... Thanks :) What I need is moving xml data from client to server & vice versa, but not using xml file. I did something like this : In server (VBScript) : ----------------------------- dim xml_list dim newnode xml_list = Server.CreateObject("Microsoft.XMLDOM") newnode = xml_list.createElement("mylist") xml_list.documentElement = newnode itemnode = xml_list.createElement("line") newnode = xml_list.createElement("element_id") textnode = "This is a text"...

Word should add image-count tool or property
MS Word should add an image-count function, either as a tool similar to Tools > Language > word count, or as an automatically generated statistic in document properties. I believe this is available in Sun's Open Office, and was quite surprised I couldn't unearth it somewhere in Word's Tools > Options. I often receive drafts to edit that contain 100 or more unlabeled graphics (i.e. can't generate table of figures) and want to know what I've got on my plate w/o counting them manually. VB scripts are great for techies, but please - how hard could it be ...

Outlook Picture Compression
When sending pictures through Outlook 2002 to someone using OE, the pictures appear in the body of their e-mail in their original size. How do I compress the picture so that they can see it? ...

Making Data and Axis Labels Different
Hi, I have a simple column chart that uses millions of units on its Y axis and puts a label above each column showing the exact value. At the moment the Y axis shos all the trailing zeros behind each million value, somethiong like: 40000000 36524102 35000000 x .. x .. x .. x 5000000 x colummns here What I would like to show is the Y axis values without the trailing zeros but the data label in full. I seem to be able to do one or the other but not ...

Multiple Instance of same form retrieving different data.
I have a form that shows Batch Jobs by name. Connected to this is a subform which shows unique Batch Job Name & Job Nbr combination records. The Batch Job Name and Job Nbr are the primary keys for the table being sourced by the subform. For Example, I have a form with Job Name of: Batch Job A and a sub form which Shows Batch Job A, 12 Steps & Batch Job A 16 Steps. The Job Nbr is hidden because its an internal number that ties back to source system. What I would like to do is give the user the ability click on the batch Job name in the sub form which will open form Batch...

Image in a cell
Is it possible to place an image in a cell? If so, can you tell me how to do it? No. Images are placed in the Drawing Layer "above" the worksheet. Cells can contain formulae or data. If you size an image to exactly cover a cell, you can set the Move and Size with Cells property (right-click on the image, choose Format Picture/Properties and select the appropriate radio button) so that the image remains "on top" of the cell. In article <6463B5FA-3D07-43B9-90EE-7A5143977C1B@microsoft.com>, "Mark" <Mark@discussions.microsoft.com> wrote: > Is ...

Combine two sets of overlapping Date/Time data into 3 columns.
I have two sets of data with Date/Time. One set has a fixed interval, the second is more sporadic. I am trying to combine into these sets into one table with the data from one set next to the corresponding data from the second set. For example: A B C D 4/22/2010 9:00 000 4/22/2010 9:01 777 4/22/2010 9:01 111 4/22/2010 9:03 888 4/22/2010 9:02 222 4/22/2010 9:06 999 4/22/2010 9:03 333 4/22/2010 9:04 444 4/22/2010 9:05 555 4/22/2010 9:06 666 Output: A ...

Email template with images
How to add images in an email template. I tried to use SharePoint Designer to design my email template and copied the entire design and paste it to MS CRM email template editor, but the images does not appear. Any help is very much appreciated. try using visual studio.net and also put it a url to the image. ============================== John O'Donnell Microsoft CRM MVP Web - http://www.crowecrm.com Blog - http://www.crowecrm.com/crowe/microsoft/crmblog.cfm "Benjamin Fallar III" <fallar@pldtdsl.net> wrote in message news:AF61147B-68F5-460A-8FDD-322CA9971F40@microso...

Show Employee Picture on form
I have an employee table that contains a picture (file name path) of each employee. The employee form works just fine, displaying the pictures. I would like to add the picture of the employee to the payroll form, that is, when an employee is choosen from a combo box I would like to have the picture show on another box. The employee and payroll tables are linked, by employeeid, could some one help me with the code to accomplish this please. thank you visidro It will work basically the same as the employee form. You will need to add code tot he after ipdate event of the control box and the...

Diaglog/Threading Data Exchange Question
Greetings, I have learned a lot from all of you, and I hope to over come my latest road block. I have a smal IRC Chat client I am making. I have a Dialog Box with Control and I use a worker thread for connecting to IRC - That Thread will update controls on the Dialog by sending PostMessages. Now my problem is in the ListBox Control that I have extended to do popup menu with various commands. I need to be able to read that controls methods from within the Thread. so I need to do this from within my IRC Socket thread: (code not exact - pseudo code) CListBoxEx myUsers; //Defined in my ...

CAE macro for green screen updates with Excel data
I am a user of the Personal Communications AS/400 (Client Access Express for Windows) WorkStation Program IBM software. I am able to record a vbscript macro to automate a repetitive update of our ERP using one of the ERP options. I need to modify the macro so that it picks up the data to be entered from an Excel list and "types" it into the appropriate input fields. I need to get it to process the entire list of values row by row. Right now the macro recorder has produced a statement like autECLSession.autECLPS.SendKeys "B11641" which I have to replace with commands to...

Data Forms #3
Hi I have a spreadsheet that I am filling in using a form. I have also a row at the bottom with blank rows in between with a running total. When I print there is a huge gap between the last entry in the form and the totals at the end. Is there a way that the form can enter the next line and push down the totals so that there are no gaps. This is what I have. Name Salary Tax Total Ann 42000 5000 37000 Joe 37500 6000 31500 Total 79500 11000 68500 This is what I want Name Salary Tax Total Ann 42000 5000 37000 Joe 37500 6000 31500 Total 79500 11000...

Use spreadsheet as data source
Hi, We have two workbooks, Bk 1 contains information relating to production scheduling and manufacturing information. Bk2 is a template used to generate a ticket (workbook) containing specific information relating to the individual order. Is it possible to transfer information between the two. Eg on Bk1 there is a packing spec worksheets for items, what size outer to use, and how many items in that outer as well as other information, can we interrogate this (search by item code) and then "autofill" in cells marked "Outer" and "Number" in Bk2 (ticket). Tha...

Best way to copy data across ?
End users are using an Access 2003 Database with both front end and back end. There is a requirement to add fields in a particular table and change the forms and reports accordingly. I have made a new copy of both front end and back end while end users are still using the database. I would like to know what is the best way to copy all data from production to the newly developed backend ? (How to import data to table) ? Thanks Why not just alter the existing backend? Kick everyone off the system briefly and make the changes. Alternatively, write VBA code to make the changes for y...

Data Table #2
Hi All, Is it possible to display the Data Table on a Pie chart, as you can in a Bar chart. Excel 2003. Thanks, kfh. Hi, Simple answer, no. Instead create your own. For more information see Tushar's page, http://tushar-mehta.com/excel/newsgroups/data_table/index.htm Cheers Andy k f h wrote: > Hi All, > > Is it possible to display the Data Table on a Pie chart, as you can in a Bar > chart. > > Excel 2003. > > Thanks, > kfh. > -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info Hi Andy, Thanks for the link, is there any way to add the...

chart displaying horizontal line for zero data
Hello, I am using a column chart in Excel. The chart is currently displaying a horizontal line when there are zeros for the data. It is working as it was designed to do... however I would like to make the graph not display a line when there is all zero data. Is there an easy way to fix this problem? Thanks Pseud In place of zeros use =NA() This displays as #N/A and these points are ignored by chart best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email <pseudonym@1NET.gr> wrote in message news:1107198704.841502.289510@c13g2000cwb.googlegroups.com.....

Exporting Data from access and appending to an existing excel sprd
I run a series of queries each month in an access form that I have created. I can export the data into a new excel spreadsheet no problem. I am just wondering whether or not there is a way to export the data into an existing excel file and append it to the bottom of data that has been exported in previous months. It's not really critical, I'm just trying to make things that much easier. Thanks. You can always use the drag and drop technique. Open the Excel file to the desired worksheet, then minimize it to your task bar. Drag a saved query from your database to the...

Pivot tables / source data
Is there a way to take a pivot table and copy and paste it into a new document so that the source data cannot be pulled up by the person looking at it? The reason I need to do this is because I have created a pivot table and included in the source data is very confidential information. I want to be able to send out JUST the actual pivot table, but I don't know how to do this without releasing all of the other information along with it. Is this even possible?? Have you tried doing <copy> (on the table), then moving the cursor to another sheet and Edit | Paste Special | Values (ch...

Collect data from spesific cell in multiple sheets
How can I collect data from cell A1 on sheet 01.01 thru 31.12 (Dates) to summary sheet? I've tried fill and copy formula with different use of ! and $ but I've not been able to solve this by my self. Thank you Hi, The correct syntax is =SUM(Sheet1:Sheet3!A1) Substitute sheet1 & sheet3 for the first/last sheets in the range you want to sum -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Espen Rostad" wrote: > How ...

Transactional Data Through DTS/SQL Scripts
Hi All, One of my client want to create new company in same SQL Server, but with different segments and format of Chart Of Account. Firstly i gave idea to use account modifier to change segments and COA within Old comapny but they require new company. Till now no problem but client also want all historical/open data for from old company to new one. I think i need one table for account mapping with old COA and New COA, then utilize that mapping through SQL Script while transfering data tables through DTS. Modules running are AR,AP,SOP,POP,GL,BR,FA,INV,HR,PAYROLL on GP 8. and SQL 2000 whats ...

Pivor Table Data Field
This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C5A644.DE8D0D20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have tried to "show" a data field after using "hide" in field = settings. How can I make this reappear? Not using Field drop down = option. The fields orgin is from the excel list and not a calculated = fields. ------=_NextPart_000_000C_01C5A644.DE8D0D20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC ...

copying data from test databases
Hello: We are getting ready to have our client go-live on GP 10.0. For the last few weeks, we have had to client "play" with their data in GP 10.0 test companies (test databases). We would like to transfer their master data from the test companies to the live companies databases. Before doing so, we will use GP's history removal utilities to get rid of the transactions that we do not want to transfer over. Which is the best and safest way to transfer this master data--by simply restoring a backup of the test databases over to the live databases or by using SQL 2005 Imp...

Display blank data rows in a report
How can I force the same set of row labels in a report even if the value is null or blank in the table? I would like my report to look like this: Year 1 Year2 Year3 ----these are the column headers Fund Name1 and the 'static' row headers are: ACTUAL HISTORIC TOTAL ORIGINAL DIFFERENCE % OF DIFFERENCE I would like to make these 6 items to show for each FundName in my report. It took me a great deal of work to get the numbers to sort of 'Pivot' . But now I would like the rows to display even if there are no values stored in the report. I would re...

CRM workflow: Error trying to write/get data into/from databse
Hi all, I've got a workflow rule which call an assembly to write the new contact record details to a database. I've got the workflow working fine on my development VM server, but when I test it on our client server, it throws an error "Object reference not set to an instance of an object" . I am just wondering what the environment issues cause that to happen, the only different between the two environments is the sql database is on another server, and VS .Net is not installed. Let me know your thoughts. Thanks in advance, -- Ahmed Can you post the complete...