- #EDIT A GRAPH IN EXCEL FOR MAC 2011 FOR FREE#
- #EDIT A GRAPH IN EXCEL FOR MAC 2011 SOFTWARE#
- #EDIT A GRAPH IN EXCEL FOR MAC 2011 PROFESSIONAL#
When I buy a pattern with a lace or cable chart, I usually break out the highlighters and colour each symbol in, making it easier to read at a glance. Now, here’s where Excel starts to really come into its own, for charting. It’s a great pattern, but a good example of one that you might want to rechart for yourself before knitting.
#EDIT A GRAPH IN EXCEL FOR MAC 2011 FOR FREE#
* I’m borrowing this lace pattern from the AeRang shawl by Jolene Mosley, available for free here. (You know, that’s only the price of one pattern PDF.) I personally prefer StitchinKnit, which has symbols for a few more complex stitches, but it’s $6.
#EDIT A GRAPH IN EXCEL FOR MAC 2011 PROFESSIONAL#
Lots of people (including Kate Atherley, WiseHilda herself, who is a professional tech editor for Knitty, among other things) recommend Aire River’s free Knit Symbol font. However, for more complex patterns, I recommend looking into a knitting-symbol font. Using the draw grid tool, you can just click and drag to draw a box with all the gridlines filled in.įor a simple lace chart like this* you can get away with using a plain sans serif font (I used Calibri here). Set the line weight and line colour (I usually opt for a light line weight in grey, rather than black, but that’s personal preference). Click on that and select the “draw grid” option. The icon on the left will have a little pencil on it. You should get a little toolbar something like the one shown below. It leads to a drop-down menu choose “draw borders.” Somewhere in your formatting toolbar, there will be a little icon showing gridlines. Now, it’s time to draw the gridlines for the actual knitted piece. (You may want to set your margins to be quite narrow, to maximize the area available for the chart itself…) You can also specify that the pattern should be scaled to fit to one page width, so the pattern doesn’t break over multiple pages. If you’re charting a shawl, chances are that you’ll want your page in landscape orientation if the chart is for socks or mittens, you might want to keep it in portrait orientation. This is a good time to arrange your page setup, too. The same works for rows, if you want to adjust those.
When you’ve got the whole thing selected, you can just grab the edge of column A and drag to adjust it, and all the other columns will automatically resize to match. Just click in the very top left corner to select the whole grid. The knit stitch is wider than it is tall, so adjust your cell size accordingly. Your version may look a little different, and controls may be in slightly different places… but every version of Excel I’ve tried will ultimately do the same things.)įirst things first.
(Disclaimer: I’m using a slightly aged Mac with Excel 2004 for this tutorial. ❖ Updated at 5:10 PM, June 6, 2011, with the image I had forgotten to save… I’m hardly an expert (at Excel OR at designing) but maybe this will prompt some others to share their tips and tricks too.
#EDIT A GRAPH IN EXCEL FOR MAC 2011 SOFTWARE#
Mostly this is sheer laziness, since it’s the software I know best from my day job, and I can’t be bothered to purchase or learn another program! Anyway, I had some tips and tricks to share with Glenna, and I promised I’d make her a proper tutorial. I do all my charting in Excel, personally.
(We were both working on Super Seekrit Projects which cannot be discussed at present, except to say that we were both wrangling charts.) I had lunch with Glenna ( Knitting to Stay Sane) not too long ago, and talk turned to design work.
0 kommentar(er)
