Tips & Tricks 2: Crochet Graphs in Excel

At one point, I used Google Drawings for my crochet graphs that I create. I just recently switched over and tried one in Excel. I much prefer Excel for the graphs now! So, on the recommendation of another designer friend, Krista of Evergreen Shore, I decided to do a tutorial on how to create crochet graphs in Excel.

Crochet Graphs 1

I start by plotting my graphs by hand on graph paper most of the time. That is not necessary but it is how my creativity flows best. I can go straight to screen to do it but I enjoy getting my colored pencils out and tweaking it to be just what I want before going to the computer. I have created blank templates for my graph sizes with numbers for the grid. How I number and which direction the design faces depends on what type of project I am plugging the graph into. This makes it easier for me to plot and for others to follow the graph.

Crochet Graphs 2

Once I have the row numbers plotted out (I do all four sides), I choose the borders for the graph.

Crochet Graphs 3

After that, it is a simple matter of filling in the blocks with color to get the design I want. I select the squares that I want to be a certain color:

Crochet Graphs 4

And then use the fill to choose the color I want. For black, I will often use dark gray; and if I don’t want to completely fill in the background, I will often use light gray for white.

Crochet Graphs 5

Once I have the graph complete how I want, I usually convert it to a PDF. Then depending on what I am going to do with it, I will sometimes take a snip and save it as a PNG or JPG file depending on how I need to use it.

What types of graphs do you want to make? Does this make you want to try one of your own? Let me know if you do!

signature1

Comments

  1. What an absolutely brilliant idea, thank you so much for sharing this with us..

  2. Thank you for the wonderful tutorial Leah! Now I am off to find my graph paper and pencils.

  3. I am trying to do an afghan with 6 names on it (grand babies) but can’t figure out how to do it without being really big. Will this work for putting multiple text blocks in it?

    Thanks. Judy Rea

    • creativethreadslf says:

      How big are you wanting to make the afghan? You could do each name in a rectangular section set at a certain size to make them come out correctly and not be too big.

  4. Cynthia Ogden says:

    What are the rows and column sizes?

    • creativethreadslf says:

      I would have to go back and look but really it can be based on preference. I just try to make sure they are “square”

  5. Kim Lace says:

    Thank you so much I was having trouble reading what I printed out before I found your tips on how to do this in excel love it now going to doing all my own designs this was ๐Ÿ™‚

  6. Hi Leah;
    Thank for listing the usage of Excel for graphs. I just have one question, what are format measures you used to make the boxes square?
    Thank You Robib

Speak Your Mind

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.