Spreadsheet background image
-
Need some help.
I've got an image that I need to write several values on, enough for me not wanting to do it in paint or other image tool and create box boxes etc.So I thought if I can add the image onto a spread sheet I can just write my values in the cells easy.
Well I can't get the image to add "under" the cells.
Any advice? I'm using Excel but happy to use anything, like OpenOffice etc
If I add the image as a background image it repeats itself.
If I add as a image it goes on top of the cells
This is an example of the image
-
This post is deleted! -
This post is deleted! -
-
@dustinb3403 how would I use that?
-
I do see what you are trying to do using Excel or Word. Seems it isn't possible.
My next thought was GIMP - but I see you would prefer to not go this route.
How often do you need to do this?
-
@hobbit666 ShareX allows you to add text wherever you want it when you take a screen capture.
Is Microsoft Word an option?
In Word, you insert/paste the picture, and then click on it. In the Layout options, you set it to "Behind Text" and then draw in arrows, or text that you want from the Insert Tab. If your image already has arrows on it, you can just line up the text box the way you want it.
In the pic below, the red arrow and the text box were both done using word. The number bubbles were done using ShareX.
-
@dafyre
Would that make ShareX similar to Greenshot? -
@gjacobse Yeah. I actually switched to ShareX from GreenShot. GreenShot could probably do it too.
-
-
@hobbit666 said in Spreadsheet background image:
@dustinb3403 how would I use that?
I took a screenshot of your picture using ShareX and then edited the image with the built in tools.
I'm assuming you're wanting to add notes, based on the yellow arrows.
/assuming
-
@dustinb3403 said in Spreadsheet background image:
I'm assuming you're wanting to add notes, based on the yellow arrows.
/assuming
Nope I need to put in reading for all the coloured lines and arrows
hence not wanting to have to manual add text boxes all over the place.
But it's looking like that's the only way.The idea of the excel was I could just click in the cell easily and just type the values
-
@hobbit666 said in Spreadsheet background image:
@dustinb3403 said in Spreadsheet background image:
I'm assuming you're wanting to add notes, based on the yellow arrows.
/assuming
Nope I need to put in reading for all the coloured lines and arrows
hence not wanting to have to manual add text boxes all over the place.
But it's looking like that's the only way.The idea of the excel was I could just click in the cell easily and just type the values
Adding text is as simple as it possible can be, you click the T icon, and click where you want it. Type whatever, and then you can move it around if you don't like the exact placement.
-
@gjacobse said in Spreadsheet background image:
How often do you need to do this?
Not often at the moment, it's only really for diagnosis of boards when I need help
Just thought it would be a nice way of putting the data on to share. -
@dustinb3403 said in Spreadsheet background image:
Adding text is as simple as it possible can be, you click the T icon, and click where you want it. Type whatever, and then you can move it around if you don't like the exact placement.
I see what your saying but that's two extra steps, click the cell and just typing would be quicker
-
@hobbit666 said in Spreadsheet background image:
@gjacobse said in Spreadsheet background image:
How often do you need to do this?
Not often at the moment, it's only really for diagnosis of boards when I need help
Just thought it would be a nice way of putting the data on to share.Try ShareX (It is Windows Only though) but it works amazingly well. Best screenshot tool I've used and has a ton of functionality without the complexity.
The only thing I do at install is disable the "Uploading" of images (which it asks the first time anyways).
-
@dustinb3403 I use greenshot but will give that a go tomorrow
-
-
This is using WORD - took a moment to sort but MAY be close to what you are trying to do.
Add image to Word, then set to BEHIND TEXT, then Using WORD Tools to add pointer, and the single row three column table.
-
@gjacobse said in Spreadsheet background image:
This is using WORD - took a moment to sort but MAY be close to what you are trying to do.
Define "a moment"
