Maybe you can crochet anything you set your mind to, but can you design anything you set your mind to?
Of course you can!
Graphghans are all the rage right now. They make wonderfully personalized gifts for people of all ages, and they’re so versatile! You can do them in straight SC/HDC/DC, in bobbles, shells, waffle stitch (!), and especially using the newly popular C2C method of crochet stitching.
I’ve been asked at least a hundred times how I design my graphs, so I decided to take the time to put together a little tutorial to show you how I do exactly that. Enjoy!
How to Use Microsoft Excel to Make Your Own Graphs
Open a blank workbook in Microsoft Excel. Note: I am using Microsoft 2013, so my menus may look a little different than yours!
- Adjust the width of all of your columns. You can do this by clicking on the little arrow on the top-left of your workbook. This selects all of your cells in the workbook. Right-click on any of the column headers and select “Column Width” from the menu.
- Adjust the column width to a value of “2.14”. This will make your columns and rows form nice little squares! Perfect for graphing!
- Select your desired graph size by clicking in one square and dragging your mouse down to form your graph size. I suggest a 25×25 or 30×30 graph to start with.
- With your graph squares selected, add some borders to your graph. You can add default black borders by selecting “All Borders” from the menu or you can add borders of a different color by selecting “More Borders…”.
- I prefer using grey borders for my graphs because I think it’s easier on the eyes than flat black borders. I select the second color option down in the second row (it’s highlighted in gold in the next picture), and then select “Outline” and “Inside” from the Presets to make the borders cover all of my selected squares.
- Add row numbers to your graph by entering the numbers in the cells below/above/next to the graph squares. If you’re going to do C2C, most C2C graphs start in the lower right-hand corner, so make the lower right-hand square your first row, increasing the row numbers as you move up and to the left.
- Add some arrows to your graph by using the Insert Shape feature. Draw four arrows: up, down, left, right.
- Copy and paste these arrows so that they follow these rules:
- Top and bottom edges of the graph:
- odd row numbers = ^
- even row numbers = v
- Left and right edges of the graph:
- odd row numbers = >
- even row numbers = <
- Top and bottom edges of the graph:
- Now it’s time to add some color to your graphs! Start with a basic concept or design you want to make. In this example, I am going to make Jayne’s striped knitted hat (from Firefly, if you don’t know the reference!). To start, I usually find an image of the shape I want to emulate in my graph. Here is the hat I will be graphing:
- Select some squares by clicking and dragging your mouse over the desired area. To add color, click on the paint bucket and select your desired fill color.
- Keep selecting your squares and filling in color. This is mostly a trial and error process.
- You can even add letters if you want!
- Or background colors!
And that’s basically it! From here, you can add a list of colors off to the side or a stitch guide, or you can convert to a PDF or just print right from Excel. There are other free versions of Excel that would probably work just fine in a pinch (LibreOffice comes to mind), but I have had Microsoft Excel since I was in college. It’s my go-to program of choice.
I hope this helps other crafters to be inspired to create their own graphs! Obviously, the more squares you have in your graph, the more detailed you can make your designs. I prefer the smaller graphs because I just don’t have the attention span to make anything much larger than 50×50 squares!
If you want to do straight SC/HDC/DC etc., you will want to adjust the graph’s row counts and arrows to reflect the straight back-and-forth motion of your work. You also don’t necessarily need numbers along the top and bottom of the graph.
If you have any questions, please don’t hesitate to ask! This method of graphing is definitely full of trial and error, but it’s the easiest way I could think of to make my graphs. Hopefully it helps you to discover a whole new world of design possibilities!