I'm not sure what you mean by "relative" position. Relative to what? To you want it to move as the user scrolls so that it always stays in the current window? Or perhaps stay positioned relative to a particular cell.
Whatever the answer, it can be done. However, one problem with pictures that "float" over spreadsheets is that you cannot easily get to the cells underneath the picture manually without moving it first.
I'm not really concerned about accessing the cells underneath the pic and I'm trying to set it up so that it is locked in position no matter where I scroll on the page (about where K1 is located on a new sheet).