Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

If you sell to woodworkers, your customers are already here

Gridlines to a photo

Posts

Gridlines to a photo

#1

Gridlines to a photo

Gary Smyth

I have a photo of a design that I want to use on a piece of painted furniture. I want to size a picture and place 1/2" gridlines over the image. I'm told that I can do that using Excel as a grid line generating device. I've been in my Excel cheater book but can't find what I'm looking for use with a picture. Anyone ever used Excel for such a task? If so how? If not, other than photoshop, other free source?

Re: Gridlines to a photo

#2

William Falberg

Re: Gridlines to a photo

William Falberg

PAINT.NET

Re: Gridlines to a photo

#3

Re: Gridlines to a photo

Ed Beck

Sure you can. Depending on what version of Excel you have the instructions will vary.

Open up Help and search for "Background".

In Excel 2007 you

1. Click the worksheet that you want to display with a sheet background. Make sure that only one worksheet is selected.

2. On the Page Layout tab, in the Page Setup group, click Background.

3. Select the picture that you want to use for the sheet background, and then click Insert.

4. The selected picture is repeated to fill the sheet.

In versions prior to Excel 2007 it's going to be in the page setup menu.

If you can't find it email me the image, tell me what version of Excel you have (so I know what version to save it as) and I'll do it for you. At least I'll insert the image, I'll let you adjust the grid lines.

I'm going to be out all evening, so I would not be able to mail it back until tomorrow.

Re: Gridlines to a photo

#4

Ellis Walentine

Interesting question

Ellis Walentine

My version of Excel (2003, SP3) will display the background on the screen but it won't print it, unless I'm missing something. Also, I fiddled with the grid sizes (row height, column width) and couldn't figure out how to make 1/2" squares as the row and column dimension units seem to be totally different (e.g., a row height of 36 is about the same as a column width of 6).

To get around the printing problem, you could do a screen capture of the sheet once you get the grid the way you want it. (Also, it seems to me that the 1/2" is arbitrary, being relative to the size of the image you want to overlay. E.g., do you want 1/2" to equal 2" in the finish drawing? If so, the size of the image must be adjusted to 25% of the actual size.)

Very interesting question. I imagine this trick could be handy for all kinds of curve layouts and so on. I'm not even sure how I'd do it in Photoshop or Paint Shop Pro. I don't think either has a canned grid that you can add as a layer over a photo. You might have to scan a piece of graph paper, adjust relative dimensions, render it transparent and then lay it over the image.

Ellis

Re: Gridlines to a photo

#5

Re: Gridlines to a photo

Tom Dunlap

I googled "gridlines to a photo" and found 150,000 hits including this:

http://tinyurl.com/ygd5kqc

Re: Gridlines to a photo

#6

in photoshop

John K Jordan

In Photoshop you can display a grid and set snap attribute (view menu), set grid spacing (preferences), and draw lines snapped to the grid. You have to draw the lines one at a time but it doesn't take too long. You can save the file in layers to reuse the grid. Print can be sized precisely, at least on my printers.

There may be an easier way but I didn't experiment. (There are usually many ways to do a given task in Photoshop, a bit like woodworking!)

JKJ

Re: Gridlines to a photo

#7

Re: Gridlines to a photo

awleonard

Not sure if this will help, but...my wife is an artist. She uses the grid technique for initial layout. I printed her a few grid patterns on transparency sheets (from any office store). They work great. She just lays them over the picture printout and tapes them on temporarily. I used CAD to draw mine, but I wonder if you could just print a blank spreadsheet with outlines around the cells? Pretty sure you can format the cells to specific heights and widths. There used to be a graph paper generator on the web somewhere.

Tony

Re: Gridlines to a photo

#8

Re: in photoshop - Record an action

Ed Beck

John - if you're using Photoshop CS4 (or some of the earlier versions) you can record the action of adding the layer, the grid, sizing the photo and adding the grid lines. Then you'll just have to run the action to get it all done with one click. If you need to you can record several different grid settings and save them.

I'm in post-production now on a few hundred basketball game photos. I use Lightroom 2 to get them uniform, then I bring them into CS4 for editing. I manually edit a few until I figure out what needs to be done, then I record several actions, and batch run them on the photos. I still do manual color adjustment, rotation and cropping of course, as well as bring them into Viveza manually, but everything post Viveza, applying a few filters, saving out as a PSD and as a JPG, is all done in batch mode as I go do something else.

For anyone who is thinking of Photoshop CS4, I know it's a hard decision because it's pretty expensive ($700 for first time purchase) but depending on what you do, it's worth it. The learning curve is steep and long, but the benefits are worth it.

If you're happy with LR2.6 that's fine. You can do a lot with LR. But if you get to the point where you start to think that LR isn't enough for you, I'd bypass Photoshop Elements and go straight to CS4.

Re: Gridlines to a photo

#9

Re: Gridlines to a photo

Gary Smyth

Ed,

My Excel version is 2003. I'm told version 2007 has the ability to do what I want with a picture and grid lines, but to the best I can figure, Excel 2003 gridlines have to be adjusted by hand and that there is no scale except by eye. The insertion of a picture as a layer underneath is somewhat difficult too. Before I impose on you further I'm going to explore "Paint" which is free. I have no money for Photoshop for this. I've looked for other stuff on the web that would build the gridlines and perhaps that would work, but what I want is elusive so far. Photo is example of one design. I need it in several scales to build a stencil(s). Where is that sign vinyl cutter when you need it? By the way, what I want to do is grab a photo, manipulate it as to size, shading etc. Take the retouched photo and apply it to a grid and print to 8 1/2" x 11" paper. If the finished size of the manipulated image (example: 16" high x 9" wide) exceeds the size of the standard sheet of paper it will print on multiple sheets and the grid lines will provide registration.

Re: Gridlines to a photo

#10

Re: in photoshop - Record an action

Joe in a Cleveland suburb

Ed, I see in your profile you are a Nikon shooter.

Have you ever checked out NikonCafe.com?

It's a nice friendly place much like WC.

Joe

Re: Gridlines to a photo

#11

Re: in photoshop - Record an action

Ed Beck

I'll head over there now. Thanks.

Re: Gridlines to a photo

#12

Print twice cut once *LINK*

Tom Dunlap

This may be backwards but sometimes I find it easier to do that instead of struggling through the learning curve.

First, print your stencils or pictures like normal.

Second, find one of the free graph paper downloads, select the scale you want, then send the picture through a second time to print the graph on top of the picture.


Graph Paper