Creating knit graph paper on mac, using Excel and Numbers

Working in Excel 2008 and Mac Numbers 3.2, reviewed 12/2022

My blog is a living document. I tend to keep old posts as they were originally written, which can help reflect the evolution in the resources used and my changing and at times growing skill in using them.
There have been many interim posts on using Numbers in knit design, whether as a stand-alone or in conjunction with other programs ie Gimp.
At times I revisit topics as separate posts, or I correct or expand the information in ones previously published, true here, toward the bottom of the post.
On a worksheet, columns are usually standardized to accommodate approximately 9 font characters. Width and height are measured in points and units such as inches or centimeters: 1 point equals approximately 1/72 inch or 0.035 cm. The default row height is app. 13 points. In developing knitting charts smaller units of measurement are preferred. Preferences (general) may be changed from the default (inches) to cm, or the smaller unit mm, and saving.
Online conversion between units of measurement and PostScript points may be calculated (if needed) using calculators ie. cell measurements in mm and points When opening an excel document, to view only one page: on the bar at the top of your spreadsheet click the View menu and then in turn choose the Customize Toolbars and Menus. The window below will appear, click on the commands tab. Scroll down to “Zoom to One Page” on the list, “click and drag” it to your toolbar, releasing your mouse button to place it using the vertical line that appears as your guide to determine its placement.
the chart toolbar with the icon (to the right of the red line, click on the image for magnification)on the standard toolbar

If the chart toolbar is in use, left-click on the arrow at the right, where Customize toolbars and menu are the second option offered; a right-click will allow you to modify toolbars as a first choice and offers the commands as an option.
Clicking on the icon now in the toolbar will show one worksheet, and adjustments may be made as follows for producing your graph paper or knit chart, clicking again will show multiple sheets once more.
Click on the diamond upper left-hand corner to select the whole sheet, now that the whole sheet is selected apply your unit choice to the whole document: place your mouse on and hold it between the cells indicated by any 2 of the letters (separator will appear), drag the boundary on the right side to define the desired width, repeat the process between any 2 numbered rows to define the height. The format menu may also be used; first, select the whole sheet, then on the home tab, click on format, and select format row height or format column width alternately to specify desired measurements The latter method may give better control over unit specs in some instances.
If the intent is to use the program as virtual graph paper on which to add color, symbols, etc one may continue editing,  and working with borders and border drawing options line thickness most suitable for printing may be selected, along with types of lines and colors. Common ratios for knitting are 4:5, and 2:3 (height to width) with stitches being usually wider than tall. Single-page workbooks to start your chart editing and saving for printing

Selecting the whole document for printing by going for the select all command in a variety of ways did not print the whole document for me or even recognize the content. Whether printing the whole document or part, the print area needs to be hand-selected. Click on the cell upper left where you want to begin, drag the mouse, and release on the last cell at the bottom right on which you wish to stop. The selected area will now appear colored blue and outlined by a broken line. In the file menu, choose the print area, and in turn to its right “select print area”. File print should in turn be operable now, along with a preview of the selected area to be printed. If you wish to have the graph paper as a permanent file, proceed as above, but from your printer screen select PDF, then save as

An online PDF generator for printing graph paper for knits (including shadow knitting) in 2 ratios and orientations may be found a

Previously posted links and more on using excel for the virtual designing of knit charts and motifs

Numbers 3.2.2,  updated to version 12.2.1 in December 2022
I chose to change my preference for rulers to point units (options are for centimeter inches and points)

default cell size in cm and points

Click on the table at top of your document screen, to the right of the function icon; select the first choice on the left, second row a place to start Uncheck alternating rows on menus on right, revise options
Click anywhere on the screen, and use the command all to select all table cells. Choose row and column size, type in your desired values, or using the arrows provided, hit return. Click anywhere on the sheet to get additional markings to appear again. With your mouse, grab and drag the _| symbol on the bottom right and you will also have the benefit of viewing the number of rows and columns in your document. Click on the circular target icon on the upper left, drag the _| symbol on the bottom right, and all units on the sheet will be resized to display measurements. For thicker, darker, or even in different colored and types of lines changes are easily made working with borders menus. Clicking on any cell leaves only your graph; selecting print from your file menu prints exactly what appears as the sheet number chosen, and /or saved; additional adjustment options are offered on right

Click on the white part of your sheet, only your chart will be viewable and ready for printing. If a PDF is desired, choose Export to -> PDF from the file menu.
I had a Ravelry request for a punchcard template. In a previous 2011/12/14/more-low-tech/, I shared a method that got me in the ballpark using a word document, for having a printable, near-scale graph. Here is an editable excel workbook resulting in as near as I could get to printing the punch card at scale; included are beginning added markings for Brother machines that could easily be altered to suit other makes; lines at the side can serve for comments or notes.
Going about printing in a different way: I captured an image from my excel template saved it, opened the image in photoshop, adjusted the image size as below, and when printed the output was nearly dead-on in terms of size and would make tracing motifs from it onto a punchcard over a lightbox super easy A downloadable punchcard worksheet
Using Numbers the closest I could get to punchcard cell size at that point was using point values, 19 for rows, 18 for columns, and printing aspect ratio remained off.
I had more predictable results in 2022
The repeat used is a part of an electronic one, adjusted to a random 24-stitch width, and it is 30 rows in height. It is placed over a hacked lightbox of sorts, with a Brother blank punchcard taped over it to hold it in place. As can be seen, marking the card in the location of future punched holes would be fairly easy. Longer repeats may require the card to be shifted up very slightly at some point, which may work well, and avoid adjusting the original file height dimensions by very small point values and printing again.  
Creating the spreadsheet using cm ruler units rather than points I came up with a template I am sharing, measuring 24 cells in width, and 60 rows in height. The program will separate the design into more than one page if needed when File Print is chosen.
In the image on the far right a blank punch card is laid over the printout of page 1 of my document on an improvised lightbox, with what appear to be accurate placement results: New downloadable documents for designing alone, should open with the points ruler setting unless you have already been using the program with the centimeter ruler setting. I cannot test the Exel documents.
For designing:
punchcard blank_excel
punchcard blank_numbers
With ruler units set to centimeters:
print card_numbers09
print card_Excel
Changing rulers in Numbers, from the program’s manual:

CUSTOM NEEDLE TAPES may be used as guides to track actions such as sequences in short rows or hooking up stitches (standard KM needles are 4.5mm apart). My color printer is defunct, so this is the grey version. Color coding or notes may be easily added to blocks for more complex fabric manipulations. A reference for some conversions of mm to points based on needle spacing, each 4.5 mm unit = 12.75 points, print the results at 100% in landscape orientation with fit checked Some tables to test, editable to suit your needs. Keep in mind the size of the print area in the document is indicated immediately beneath the page orientation illustration, in points.
The last table in the document is designed for use on 35 stitches arranged in mixed-width segments. It has been printed and is shown here on the machine, placed under a random needle group, with corresponding needle selections in and out of work. The topic was revisited here. A variety of printable tapes for multiple gauge knitting machines is offered by Claudia Scarpa in her blogpost.

Leave a Reply

Your email address will not be published. Required fields are marked *