EyeLoveKnots

  • Home
  • Crochet
    • Free Crochet Patterns
      • Colin Drew Series
    • Crochet Pattern Reviews
    • Crochet 101
  • Knitting
  • Crafting
    • Plastic Canvas DIYs
    • Jewelry DIYs
    • Sewing
    • Cross Stitching
    • Upcycling
    • Other DIYs
  • Seasonal DIYs
    • 4th of July DIYs
    • Back to School DIYs
    • Christmas DIYs
    • Easter DIYs
    • Fall DIYs
    • Halloween DIYs
    • Spring DIYs
    • St. Patrick’s Day DIYs
    • Summer DIYs
    • Thanksgiving DIYs
  • Seasonal Round Ups
    • Valentine’s Day
    • St. Patrick’s Day
    • Spring
    • Easter
    • Summer
    • 4th of July
    • Fall
    • Halloween
    • Thanksgiving
    • Christmas
    • Winter
  • Home DIY & Decor
    • In the Bathroom
    • In the Bedroom
    • In the Dining Room
    • In the Kitchen
    • In the Living Room
    • Kids Room
  • Fashion
    • Nail Art
  • Recipes
  • Blogging World
  • Living the Dream
  • Fun Finds Around the Web
  • Linking Up To…
  • Privacy and Sharing Policies
  • About Our GREAT Team!
  • Work with EyeLoveKnots
  • Latest News & Links

Using Google Sheets to Create a Graph for Yarn Patterns – Photo Tutorial

January 12, 2016

Before I begin, I must confess… I have had my laptop for over 5 years and have never figured out how to use the Print Screen button until today! I seriously have thought it was defective this whole time… Hehe. But I am so happy to have figured it out because now that opens lots more doors for me (and you)!
 
I have taken the initiative and planned out some of my projects for 2016. The plan includes Crochet and Needlepoint on Plastic Canvas. I am sure many others will sneak in and the plan will be rearranged, but I am feeling accomplished and can focus more now that I have a general idea of my coming weeks.
 
I usually sketch out my plastic canvas projects on graph paper, and then redo the sketch on a clean piece but as I was sketching out some designs, I was running into some issues of not being able to really see what I was envisioning. I could of course used colored pencils, but then you can erase. 
 
I decided to search around on the web to see if anyone had a simple solution to my dilemma. I found several neat resources, but not exactly what I wanted plus I don’t have any programs on my computer such as Word or Excel – I rely on my Google Drive, and have been very happy with my experience so far. The discovery of the ease of using Google Sheets was no exception.
 
I have a fun group of projects coming your way, so stay tuned!
 
Click on any photo to see a larger version. I had to do a lot of tinkering to get them to appear as they do and cannot get them any larger.
Once in the Google Drive:
Click big red “New” button located on the left side of the screen.
Select “Google Sheets” from the drop down.
First, you’ll need to resize your blocks. You’ll only be editing the columns – Lettered tabs.
I tried to highlight several column to edit but was unsuccessful. I did each one one-by-one.
To Edit the Column Width: Scroll up to the right hand corner of a letter tab. You will notice a small arrow. Click it.
01.13.16 UPDATE: You can highlight multiple columns and resize at once. Click on and Highlight the lettered tabs, not the actual grid. Then, right click and select “Resize Columns X – X …”
Select “Resize Column” from the drop down.
A little box will pop up that will have the dot placed next to the first option, “Enter new column width in pixels…”. Change the default 100 to 20. Click “OK”.
Do this across the screen. Do not adjust the numbered side of the chart.
Don’t worry about being limited to 26 blocks across. You can add more as you see I have here.
Highlight the squares you want to color by holding down the “Ctrl” button on your keyboard and clicking the individual squares.
*If you mess up (as I have above), you can’t unclick squares here. Just go with it, and uncolor them afterwards by using the same method.
You can also highlight a large portion and color as well.
As you can see here, I changed words after I realized I was going to have to adjust and add more columns. Hehe.
To color, select the “Fill Color” icon – the little paint can. I used “dark red 1” here.
And there you have it! Now you can use this graph to work a cross stitch, plastic canvas or crochet project – to name a few!

Copyright 2016 – All EyeLoveKnots Patterns, Photos and PDF’s are protected under copyright. They are not to be copied, distributed or sold – doing so is copyright infringement and stealing! Link directly to this blog page. DO NOT PIN ANY OF THESE PHOTOS, except the first one (title)! The option has intentionally been disabled. Feel free to use this information to make and sell your own items.

Your tips and feedback are much appreciated!

Don’t miss out on new crochet patterns, reviews, jewelry tutorials and more! Subscribe to EyeLoveKnots by using the box on the right side toolbar, or follow me via Bloglovin!

Filed Under: Crochet, Other DIYs, Uncategorized Tagged With: Blogger Help, Crochet How To, Needlepoint How To, Photo Tutorial, Plastic Canvas How To

❮ PREVIOUS POST

Moray Slouchy Hat – Crochet Pattern Review – AG Handmades

NEXT POST ❯

Penguin Earrings – Free Plastic Canvas Pattern & Jewelry DIY

Comments

  1. Silvia Sánchez says

    January 12, 2016 at 8:50 am

    Love this! Thank you!

    Reply
    • knots1prime says

      January 12, 2016 at 9:26 pm

      🙂 Glad to hear

      Reply
  2. Rhelena says

    January 13, 2016 at 3:46 pm

    Thank you so much for this. I've bookmarked it for future reference. 🙂

    Reply
    • knots1prime says

      January 16, 2016 at 6:47 pm

      Would love your feedback on the process once you give it a try.

      Reply
  3. JOY @ http://joysjotsshots.blogspot.com/ says

    January 19, 2016 at 12:44 am

    Smart idea! I may try this for quilting blocks as well.

    Reply
  4. Barbara F Holt says

    June 29, 2021 at 1:58 pm

    Is there a way to scan a coloring book page on the graph and make it a stamped cross stitch pattern?

    Reply
    • Alexandra says

      June 29, 2021 at 2:56 pm

      You can scan it and save to your computer, and then upload to a program (site actually) like Stitch Fiddle, which has the option for graphs in different crafts. You can use Stitch Fiddle for free, but have to pay to download your graph.

      Reply

Leave a Reply Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Welcome!

Welcome!

Hey! I'm Alexandra, the blogger and creator behind EyeLoveKnots and On Rockwood Lane! My passion is being creative. My favorite thing to do is crochet, and you will almost always find me having a cup of coffee and working on a new crochet project, but when I'm not doing that, you might find me out at a local park rollerblading, baking some fresh cookies, picking veggies in the garden or re-decorating for a new season or holiday. My two cats are great supervisors for all my adventures (minus the being outside because they think it's too hot in Florida to be anywhere but inside), and make sure I take plenty of breaks.

Meet the Team!

Meet the Team!

Abby, Candace, Maggie & Jessica help me bring awesome crochet projects to you! They are awesome, and so talented! Click the image to learn more about them, and get their Instagram links, where they are constantly sharing tons of crochet inspiration.

Don’t Miss Out

Crochet! Magazine Spring 2023

Crochet! Magazine Spring 2023

(Affiliate Link) Click this image to get this issue now. These 22 designs are the perfect way to welcome in Spring with easy to wear layers, sweet styles amplified with striking stitch patterns, and some fun whimsical projects too.

Crochet World Autumn 2023

Crochet World Autumn 2023

(Affiliate Link) Click this image to get this issue now. There are more than 30 crochet patterns in this Autumn issue to work with the transition from Summer to Fall including catchalls and baskets to help get your stash and craft room organized, and cozy afghans, cardigans and accessories.

Gnome Caddy Pattern

Gnome Caddy Pattern

(Affiliate Link) Click this image to get a copy of this pattern! This adorable little Spring Gnome Caddy has a place for all of your crochet supplies. It's worked in a lightweight #3 yarn, but work in a worsted weight #4 yarn for even more space!

Archives

Copyright © 2023 EyeLoveKnots · Custom site by Moonsteam Design