TIP 3: How to create crochet graphs in MS Excel

Hi, recently I came up with an idea that I want to crochet a cube consisted of squares (I present the results in my YouTube video tutorial - introduction to pixel-crochet series). I thought it would be great to place something in that square, so I tried to create my own version of numbers, letters and images (a kind of pixel art).
It is such a great fun to make something from nothing - I started drawing within grid lines in my notebook, but it is definitely better to use Microsoft Excel to make crochet graphs :-) And it is simple.


Read below how to do this:

1. Open a new document in MS EXCEL. You can change the ruler units.
FILE > OPTIONS > ADVANCED
Under DISPLAY change the RULER UNITS, as you wish.
I chose millimeters.


2. In bottom right corner click on the icon of PAGE LAYOUT - you get separate pages and it is easy to save your project as PDF (every chart is on separate page).



3. Now change the COLUMN WIDTH and ROW HEIGHT (right click on the horizontal and vertical rulers). I changed to 0,95 mm for my project (I use Excel in Polish but hope you manage to read the photo).










4. Apply cell BORDERS.

I also added the numbers of columns and rows. 

How should we read the crochet square pixel graph?

 

We read from bottom-up.
Every row = the row in our work.
Every square = one stitch (in my project it is single crochet).

I start from bottom left corner (x) and crochet 20 ch (we have 19 ch + 1 turning chain). Row of chains is not numbered (red line on the photo).
Turning chains are indicated by red dot at the end of every row.

Every row counts 19 sc + 1 turning ch and after thet we turn the work.


On the scheme blue arrows indicate the direction of reading the pattern.

Odd-numbered - from right to left (it's right side of our project).
Even- numbered - from left to right (it's left, wrong side of our project).

While changing colors in the row we should remember to keep the ends of yarns on the wrong side.

When I change colors within narrow area I don't cut the yarns, but keep the proper tension of yarn.
When area is wider (e.g. we have a long piece of yarn on both sides of the square) we may cut the yarn and secure the ends to avoid deformation of square (in my tutorial i often won't cut the yarn to speed the work up).

On the scheme presented above I use only two colors of yarns, but I show you more colors in my other projects (pictures). It is worth developing your own manner to overtake the yarns if we not want to entoil with the yarns.

I attach the link to xls document - you find here blank sheets adjusted to my crochet squares.


Hope the information is useful for you :-)

Good luck while creating your own graphs! If you have any question, write in comments and I will try to help you.

Komentarze