Your Universal Remote Control Center
RemoteCentral.com
Custom Installers' Lounge Forum - View Post
Previous section Next section Up level
Up level
The following page was printed from RemoteCentral.com:

Login:
Pass:
 
 

Topic:
Excel - how to attach or reference a picture
This thread has 7 replies. Displaying all posts.
Post 1 made on Thursday March 17, 2016 at 15:29
Mario
Loyal Member
Joined:
Posts:
November 2006
5,681
I have a wire table.
It has all sorts of info about location, type of cable, color, use, termination style, comments, etc.

Still, it would sometimes be nice to take a picture and have it referenced to a particular wire.

I know I can create a column and have hyperlink or text with destination such as C:\users\mario\dropbox\projects\160317-1.jpg

Is that the best way, or is there a way to create an Excel tab, dump all the pictures there, and be able to reference to it somehow?
Post 2 made on Thursday March 17, 2016 at 18:25
King of typos
Loyal Member
Joined:
Posts:
June 2002
5,275
Why not just drag and drop a picture into Excel? You may have to go into the Picture Format tab in Excel to make adjustments.

I just added a 3264 × 2448 picture, not sure what that is as it doesn't mention if it's pixels, inches or what not. However, in Excel it's measured in inches and it was very large. 34"H and 43.35"W. I changed the H to 1 and the W followed suit to it's portioned size.

You obviously can move it around freely, or have it snap to positions. Make it transparent and what not.

KOT
Post 3 made on Thursday March 17, 2016 at 18:50
BisyB
Advanced Member
Joined:
Posts:
May 2006
964
Generally I embed pictures for visual appeal:

1. I'll size the pictures to desired size first to save space
2. Just add and lock the cell in the table

Or this site has a good tutorial for referencing pictures so you can adjust your table and then just type in the name of the picture you want to show up.

[Link: excelguru.ca]
Web Design | Hosting - www.bz303.com
OP | Post 4 made on Thursday March 17, 2016 at 19:20
Mario
Loyal Member
Joined:
Posts:
November 2006
5,681
On March 17, 2016 at 18:25, King of typos said...
Why not just drag and drop a picture into Excel? You may have to go into the Picture Format tab in Excel to make adjustments.

I just added a 3264 × 2448 picture, not sure what that is as it doesn't mention if it's pixels, inches or what not. However, in Excel it's measured in inches and it was very large. 34"H and 43.35"W. I changed the H to 1 and the W followed suit to it's portioned size.

You obviously can move it around freely, or have it snap to positions. Make it transparent and what not.

KOT

I just tried that.
Added picture that I just took, which was 4.7MB.
Re-sized it to make it smaller.
Saved the file and closed Excel.
Opened it again and made it bigger so I could see the details.
All the details are now gone. I can make out that the picture is what it is, but the wire colors and finer details are all gone.
Post 5 made on Thursday March 17, 2016 at 21:05
Ernie Gilman
Yes, That Ernie!
Joined:
Posts:
December 2001
30,104
On March 17, 2016 at 18:25, King of typos said...

I just added a 3264 × 2448 picture, not sure what that is as it doesn't mention if it's pixels, inches or what not. However, in Excel it's measured in inches and it was very large. 34"H and 43.35"W.

Somewhere I've seen that monitors show 96 pixels to the inch. 34 inches of height would be 3264 pixels.

On March 17, 2016 at 19:20, Mario said...
I just tried that.
Added picture that I just took, which was 4.7MB.
Re-sized it to make it smaller.

In so doing, lost details as you squeezed pixels together.
Saved the file and closed Excel.
Opened it again and made it bigger so I could see the details.
All the details are now gone. I can make out that the picture is what it is, but the wire colors and finer details are all gone.

As pixels were squeezed together.

If you reduce it to 25%, groups of 4x4 pixels will be represented by one pixel (I think). If you then enlarge it, those lost details will become larger lost details. Not what you want.

As you practice this approach, you'll find how much you can reduce it to have it maintain the details. I've done this using plain old MS Paint. Also remove blank edges and other details that don't really tell the story. If five colored wires come off of a spool and go to the left, delete the right half of the spool -- it doesn't help you!

I've got several ways to use Paint for this. Ask if you want details.
A good answer is easier with a clear question giving the make and model of everything.
"The biggest problem in communication is the illusion that it has taken place." -- G. “Bernie” Shaw
OP | Post 6 made on Thursday March 17, 2016 at 21:14
Mario
Loyal Member
Joined:
Posts:
November 2006
5,681
On March 17, 2016 at 21:05, Ernie Gilman said...
Somewhere I've seen that monitors show 96 pixels to the inch. 34 inches of height would be 3264 pixels.

In so doing, lost details as you squeezed pixels together.
As pixels were squeezed together.

If you reduce it to 25%, groups of 4x4 pixels will be represented by one pixel (I think). If you then enlarge it, those lost details will become larger lost details. Not what you want.

As you practice this approach, you'll find how much you can reduce it to have it maintain the details. I've done this using plain old MS Paint. Also remove blank edges and other details that don't really tell the story. If five colored wires come off of a spool and go to the left, delete the right half of the spool -- it doesn't help you!

I've got several ways to use Paint for this. Ask if you want details.

Thanks Ernie,
I was hoping that Excel would treat pictures as a vector based graphic, sort of like PDF, where details aren't lost based on SHRUNK dimensions of the picture.

I used MS Paint years and years ago, but have switched to MS Picture Manager.
Infinitely more flexible, easy to crop, re-size, shrink, etc..
Best of all, you can save images in relatively small sizes by using JPG or GIF file format, unlike Paint, which last time I tried it, only allowed saving files in HUGE BMP.



Give Office Picture Manager a whir:

" frameborder="0" allowfullscreen>
Post 7 made on Thursday March 17, 2016 at 21:22
Ernie Gilman
Yes, That Ernie!
Joined:
Posts:
December 2001
30,104
Paint's default has been jpg for years, but now it's png. You can save as

monochrome, 16 color, or 256 color bmp, though I can't imagine why anyone would, or
24-bit bmp, png, jpeg, gif, and tiff.

I almost always save new as pngs, though jpgs are almost as good. I haven't tried editing any gifs, though!
A good answer is easier with a clear question giving the make and model of everything.
"The biggest problem in communication is the illusion that it has taken place." -- G. “Bernie” Shaw
OP | Post 8 made on Thursday March 17, 2016 at 21:23
Mario
Loyal Member
Joined:
Posts:
November 2006
5,681
Here is another one:


" frameborder="0" allowfullscreen>


Jump to


Protected Feature Before you can reply to a message...
You must first register for a Remote Central user account - it's fast and free! Or, if you already have an account, please login now.

Please read the following: Unsolicited commercial advertisements are absolutely not permitted on this forum. Other private buy & sell messages should be posted to our Marketplace. For information on how to advertise your service or product click here. Remote Central reserves the right to remove or modify any post that is deemed inappropriate.

Hosting Services by ipHouse