I LOVED THIS VIDEO!!!! I started charting my fair isle work with Excel last summer, but I was unaware that you could use the dropper function with an external photo. Thank you! I would like to respectfully make folks aware that when you personalize your own color chart from a paid or free pattern, you are basing it on someone else's work. I have seen many post their spreadsheet color charts (which were beautiful) on social media to show colors they were going to use for paid patterns. These contributors were gently reminded that viewers could use their spreadsheets in lieu of having to pay or acquire permission to use the pattern. The Da Crofter's Kep pattern is currently free, but I wanted to highlight a downfall of posting customized color charts for paid patterns. Customized spreadsheets for colorwork are works of art in themselves and one can't help but be proud of their creations.
Slap my head moment😲🙀. This is fantastic and well demonstrated for those of us unfamiliar and willing to learn about excel for this purpose. Thank you for sharing👍👌👏
This is brilliant. I have been knitting for 40 years and have been a CPA for 30 years and literally live in Excel- yet I have never thought to do this. Also, I have the same issue with light and dark. I use Knit companion on an iPad and put a corresponding color dot in the squares. But I love this as you can virtually swatch for colors!!
Oh no, that's not stupid. I do the same. Thank you soo much for this explanation. I have tried before to make something like this but I don't have the skills. But now I do. 😍🥰
I use Excel to chart cables, color, keep counts, or pattern modifications. I just didn’t think to use conditional formatting for color! What a great idea, your way is faster, and easier to sample color combinations.Thank you! PS: I have that inversion problem too, and when I’m reading the reverse side of charts! I always manage to turn myself around with the purls as knits and viceversa. That’s why I prefer to knit on the round or rechart, otherwise, I spend a lot of time frogging and re-knitting.
Oh my goodness. I never thought to do this!! And I’ve always felt I can’t pick my own colors for fair isle because I couldn’t visualize what it would look like. This is awesome. Thank you so much for sharing this tip! 🤗
Ladies this video was one of the best things I've learned in a long time when it comes to knitting. I am going to try this on my next colorwork project and maybe it'll make me like colorwork thank you so much. Rachelle in Seattle
You can go to the following website and upload a picture. You're able to find out a color from there, then just plug your color into excel. imagecolorpicker.com
I'm not exactly sure what you're asking... By "shapes" do you mean the overall pattern? It comes from the pattern linked below in the video description.
FAN FECKIN TASTICILOVE IT SO HANDY
Nerds Who Knit. Totally awesome idea. Thanks!
Brilliant, nerds!
I LOVED THIS VIDEO!!!! I started charting my fair isle work with Excel last summer, but I was unaware that you could use the dropper function with an external photo. Thank you! I would like to respectfully make folks aware that when you personalize your own color chart from a paid or free pattern, you are basing it on someone else's work. I have seen many post their spreadsheet color charts (which were beautiful) on social media to show colors they were going to use for paid patterns. These contributors were gently reminded that viewers could use their spreadsheets in lieu of having to pay or acquire permission to use the pattern. The Da Crofter's Kep pattern is currently free, but I wanted to highlight a downfall of posting customized color charts for paid patterns. Customized spreadsheets for colorwork are works of art in themselves and one can't help but be proud of their creations.
Very good point!
I taught myself to use Excel for my colourwork but Lindsey took my learning to another level! Thankyou for sharing!
Glad it was helpful!
Slap my head moment😲🙀. This is fantastic and well demonstrated for those of us unfamiliar and willing to learn about excel for this purpose. Thank you for sharing👍👌👏
This is brilliant. I have been knitting for 40 years and have been a CPA for 30 years and literally live in Excel- yet I have never thought to do this. Also, I have the same issue with light and dark. I use Knit companion on an iPad and put a corresponding color dot in the squares. But I love this as you can virtually swatch for colors!!
Janna you are brilliant and clear. Great teacher.
Brlliant idea! You've saved me hours of time and my eyesight!
When I worked full time I used excel every day .. I love this .. I have been using colored pencils on graph paper.. thank you for updating my brain.
This is truly an awesome idea! Then I can print it as a pdf and import it to Knit Companion!
Yes you can!
Wonderful. Thank you .
Awesome!!!👍👍
Love excel! Used it all the time when I was working.
AMAZING! ditto on every comment below. I love the way you teach and interact - now this I can understand and do so THANKS and be blessed for sharing 🤗
I love the suggestion! Thank you, Lindsay and Jana!
Our pleasure!
Oh no, that's not stupid. I do the same.
Thank you soo much for this explanation. I have tried before to make something like this but I don't have the skills. But now I do. 😍🥰
Thanks for the awesome colourwork tutorial...saved this video and will definitely be using it to pick colors...cheers!
You’re welcome 😊
I use Excel to chart cables, color, keep counts, or pattern modifications. I just didn’t think to use conditional formatting for color! What a great idea, your way is faster, and easier to sample color combinations.Thank you!
PS: I have that inversion problem too, and when I’m reading the reverse side of charts! I always manage to turn myself around with the purls as knits and viceversa. That’s why I prefer to knit on the round or rechart, otherwise, I spend a lot of time frogging and re-knitting.
omg thats awesome!
Love learning something new. Thank you for the informative video.
i had the inversion problem the last time i knit the caladenia shawl
I was this many years old.... Thank you for sharing, Lindsey!!!! I will definitely use these tricks in my next project. Keep the video coming, Jana :)
Glad it was helpful!
Thanks for this. Now I have a reason to use Excel! =)
Thank you. Now I will see if my daughter will do this for me!
Oh my goodness. I never thought to do this!! And I’ve always felt I can’t pick my own colors for fair isle because I couldn’t visualize what it would look like. This is awesome. Thank you so much for sharing this tip! 🤗
Excellent ! - Thank you.
Hi this is brilliant.This way I will be able to have a rough idea how the colours will look before purchasing yarn . Thanks
Ladies this video was one of the best things I've learned in a long time when it comes to knitting. I am going to try this on my next colorwork project and maybe it'll make me like colorwork thank you so much. Rachelle in Seattle
I love this so much. Wow. 😃
Amazing!!!!! Thank you SO much!
This is a game changer ! I'll be able to process my chart with ease, thank you so much ladies !
Thank you so much xx
Such a wise advise, love it, thanks so much for sharing ❤️
Nhanks. This has given me an idea for a python knitting project :)
Great video. I am on a Mac and use Numbers but very rarely. Has anyone tried this is on Numbers? If so I’d love to talk to you.
I have done this on numbers!!!
Now we need computer classes. Lol
ps i was going to do this with graph paper and colored pencils i just bought!!!!! lol
I love this! I have a new edition of Excel and it doesn't have the eye dropper. How do you choose the colour then? Thank you!
You can go to the following website and upload a picture. You're able to find out a color from there, then just plug your color into excel. imagecolorpicker.com
@@lindsaydouglas8114 thank you
What program do we use on a Mac laptop? Anyone know?
Google sheets or Apple numbers!
How did you get the shapes?
I'm not exactly sure what you're asking... By "shapes" do you mean the overall pattern? It comes from the pattern linked below in the video description.
Old knitters use paper and colored pencils! : )