Creating Gauge-Specific Graph Paper

Voiced by Amazon Polly

Matching graph paper and project gauge… yay!

I like knitting charts. I’m not a particularly visual person, but I do find that charts provide me with a sense of security that I’m ‘on the right track’ with my knitting.

Naturally, since I think charts are helpful, I like to include them in my designs. But, not just any square graph paper will do! I prefer to have graph paper that approximates the gauge of the project I’m designing.

There are lots of knitting chart applications on the market and some of them have options for changing the graph to match the project gauge in addition to their excellent stitch symbol libraries. But, when my design is just a simply colorwork pattern, I just find it easier to use Excel to create charts.

Recently, I was telling a friend about my use of Excel for knit charts and she was keen to know more. So, in case you’re also interested, I’ve put together some quick videos on how to create gauge-specific graph paper in Excel. And, if you wish, you can download the Knitting Graph Paper.

This video shows how to calculate dimensions of each individual stitch and use them to set column & row dimensions in MS Excel to create gauge-specific graph paper.
This video shows how to set margins and orientation to get the size of graph paper you need. It also shows how to use the series fill function to label your stitches and rows automatically.

Your Thoughts?

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