Name Graphs

Hi all!

I have seen a lot of people wondering how to make their own name graphs for various projects, so I thought I’d create a walk-through on how I do it. I use Excel for this. You can use this tutorial on Mac or Windows. Let me know if you have any questions!

Before you start working in Excel, make sure you know which alphabet you want to use.  Pinterest has a ton, especially if you search for “perler alphabet”.  Make sure you have this alphabet saved as an image somewhere on your computer, unless you want to just freehand the letters.  Totally up to you 🙂

First, open a blank Excel spreadsheet.  Adjust the height & width of the cells so that they are all even. {Click on the cell in the uppermost left hand corner so that all cells are selected.  Right-click on any row to adjust the size for all rows; right-click on any column to adjust the size for all columns.} I use .5 – this works especially well if you are creating something on the larger size.


Second, format the cells you are going to use so they all have a black border.  {Select the cells you want.  Right-click and select Format cells…, then click on Border.  Click on Inside and Outside.}


Third, insert your alphabet image. {Insert —> Photo —> Picture from file… then find and select your image.}


Fourth, copy and paste your image however many times you need to in order to match the number of letters in the name you are creating (so Lisa would be copy and paste x4, Emily copy and paste x5, etc.) {Right-click and select Copy, then do the same and select Paste}

Screen Shot 2017-02-05 at 19.32.40.png

Fifth, crop each image so that only the letter you need is left. I’m going to use my own name for this example. {Look for the Format Picture menu, then select Crop.}


Sixth, adjust the size of each letter until it matches what you want.

Screen Shot 2017-02-05 at 19.39.30.png

Seventh, increase the transparency of each image so that you can see the letter as well as the graph beneath it. {Transparency levels should be found in Format Picture menu.}


Eighth, fill in the blocks according to your images.


Lastly, delete the images on top of your colored blocks and adjust as necessary.  Congratulations! You’ve just created your very own name graph 🙂


I hope this tutorial is helpful!  Please let me know if you have questions or if something in this tutorial is unclear.

Happy crocheting!





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s