Watermarked images, lattitude, longitude, cell references..

[Neil]

Hi All,

I am currently putting together some sales summary data and wish to overlay
the data on top
of a map of the geographic area to which the data relates, basically I have
decided to size the
cells small enough so that each cell has a height and width = to 1 degree of
lat. and long.

The sum of value of customers that are in a given location (my nominal 1
degree block) will
show in that location on my spreadsheet and I will use conditional
formatting to class the sales
value within defined ranges of value.

My question is, how can I achieve this without using a background, which
gets tiled onto the spreadsheet.
I want one instance of my map on the sheet and I want it in the background
so that my colored cells show
in the foreground.

I have tried pasting a pic in. but no matter how many times I 'send it to
back' it still resides in front of the
cells.

Ideas please ????

 

[Ron de Bruin]

Hi Neal

Try this

If you insert a Autoshape to your sheet you can place
a picture in it, here is a example for a comment (same for Autoshape )
http://www.contextures.com/xlcomments02.html#Picture
(change transperancy to your needs)