How to make your own knitting chart in Excel
A knitting chart is a visual map of stitches, with one cell standing for one stitch and each horizontal line representing a knitted row. It lets a maker follow colourwork, lace, cables and textured patterns without unpicking a long set of written instructions. Building one in Excel gives you a reusable grid, quick calculations and clean printing options, even if your spreadsheet skills are still growing.
Before opening Excel, decide what the finished fabric should look like and how it will be read. A useful workflow moves from measurements to a symbol key, then to a tested repeat. The result can serve a single swatch, a garment pattern or a lesson handout, and it can be adjusted whenever your yarn, tension or design changes.
Plan the chart before opening Excel
Start with the knitted shape, not the artwork. Record the finished width and depth, the gauge in stitches and rows per 10 cm, and any border that will sit outside the charted motif. Excel can then calculate the usable stitch count and how many whole repeats fit. For example, a 70 cm panel at 22 stitches per 10 cm with 10 cm of edging leaves 132 chart stitches. A 12-stitch motif fits exactly 11 times, leaving no awkward half-repeat.
Before designing the grid, settle these practical details:
- Measure the finished panel rather than the loose yarn or schematic.
- Confirm the gauge from a washed swatch in the yarn you intend to use.
- Count one repeat across and up, including any turning or mirrored section.
- Mark the first and final rows that will appear on the right side.
- Limit the first design to a handful of distinguishable stitch symbols.
Use the pattern draft as a working sketch for colour placement and any central motif. The Excel version should record structure, not replace every note in the written pattern. Keep separate notes for increases, decreases, row-by-row colour changes and finishing instructions; these details are easier to follow beside the chart than inside its cells.
Build a clean stitch grid
Create a workbook with three sheets: Chart, Codes and Legend. Put numeric values or text labels in Codes, display the symbols on Chart, and use Legend to connect each symbol to its stitch meaning. Start with a small tile, such as five stitches by five rows, before copying it across the full panel. This makes errors easier to isolate and keeps the workbook manageable on an ordinary laptop.
A few spreadsheet choices will make later edits much easier:
- Freeze the top and left panes so row and column references remain visible.
- Make chart columns narrow and set row heights to roughly 18 to 24 points.
- Apply light borders to every chart cell for clear stitch boundaries.
- Use strong contrast between symbols, cell backgrounds and grid lines.
- Keep raw codes on a separate sheet so changing a symbol does not alter the motif.
Number rows and columns outside the motif. Simple formulas such as =ROW()-1 and =COLUMN()-1 can create sequential labels, while a repeating fill handle can extend the grid. Centre marks, arrows and row notes belong in a narrow margin so they never look like extra stitches.
Turn cells into readable stitch symbols
Keep the chart itself visual by mapping the code sheet to symbols with a formula. For codes 1 to 5, a formula such as =CHOOSE(Codes!B2,"โ","โฒ","โก","โ","โ") can replace the value in the matching chart cell. Copy it so the reference moves with each position. SWITCH works similarly when you prefer named codes such as K, P and YO. Test the formula in a few cells before filling the whole range, because a shifted reference will repeat the wrong symbol across the pattern.
Build the legend beside or below the chart and describe each symbol in plain language: knit, purl, yarn over, slip one, decrease and so on. Pair shape with fill colour when the design needs many colours, since some makers distinguish symbols more readily than shades. A clear key is also essential if the chart will be printed in greyscale or read by someone with limited vision. Choose high-contrast combinations and avoid assigning meaning to colour alone.
Most Australian knitters work in the usual Western style, so right-side rows are generally read from right to left, with the chart read from the bottom upwards. Wrong-side rows can run in the opposite direction, but the chart should state its convention clearly. Centre and edge markers help prevent an accidental shift, especially when a project ends with grafting; the studio's Kitchener stitch walkthrough is a useful check for that finishing stage.
Design repeats, colourwork and borders
Use Excel's MOD and INDEX functions to extend a motif without redrawing every cell. A tile stored in B2:F6 can repeat across a larger grid with a formula based on MOD(ROW()-2,5) and MOD(COLUMN()-2,5). Change the divisors when the repeat has different dimensions. Mirrored or chevron sections need a second tile and a rule that identifies which half of the repeat appears in each position. Preview the joins before adding a border, since an off-centre motif can make an otherwise regular chart look wrong.
For colourwork, maintain a palette sheet listing each colour, its code and the yarn used. Australian Merino is a familiar choice in the local market because its fine fibres make a smooth, light fabric, but the chart should describe colours in the same order as the yarn labels and written instructions. Independent yarn shops and weekend craft markets in Sydney, Melbourne, Brisbane, Adelaide and Canberra often carry a broad mix of local and imported fibres, so naming codes such as MC, MC1 and MC2 is safer than relying on colour names alone. Gauge can vary between fibres, which makes a swatch and clear notes essential.
The simple chevron blanket offers a practical example of a repeat that expands from a small motif into a larger fabric. When adding a border, keep its width in the same units as the chart and mark decreases outside the main grid. Australian patterns commonly pair metric needle sizes with yarn labels such as 4 ply and 8 ply, so include the needle and tension details alongside the chart. These local naming conventions help readers select the correct yarn and make a fair substitution.
Test, print and share the finished chart
Knit a small swatch of the motif before committing to the full project. Check that every row has the expected number of stitches, that symbols match the legend and that the edges repeat cleanly. Read the chart in the same direction as the sample and compare the first row with the last visible row. A printable project checklist can be adapted to record gauge, colours, needle size, repeat checks and finishing steps without crowding the spreadsheet itself.
Print a test page on A4 paper, the standard size used by many Australian households and craft rooms. Keep the chart at 100% scale first, then check whether symbols remain legible and the legend stays on the same page. Export a PDF for a reliable master copy, or save a PNG for digital lessons. Use clear print areas, repeat headings on each page and enough white space around the grid. The workbook should remain editable, but a locked PDF prevents accidental changes to a pattern shared with students.
Once the swatch, repeat joins and page layout all agree, the chart is ready to support a larger make or a workshop handout. A digital PDF can accompany the pattern notes, while an editable workbook gives experienced makers flexibility to change sizes. The same chart can also become a reference for an online class, with the symbol key visible beside the grid. A well-tested Excel chart becomes more than a design file: it is a precise, adaptable tool for teaching, planning and sharing the next project.