Thread Size Chart–a start

Last year, I pulled out a unique thread from my collection, using it for a project other than tatting and was wondering what size/kind of thread it was. Then I notice that the label had either yards or meters per weight of the ball printed on it. This started my ‘Thread Size Comparison’ Quest that I continue to this day. This was the original chart that I was somehow able to create to show my quantitative/scientific analysis of thread size based upon length (yards or meters) per weight. I chose to illustrate my charts with YARDS per 50 GRAMS.

The above chart has 54 threads charted but on my current Excel spreadsheet I have 107 threads charted. Threads included are crochet cottons, perle/pearl cottons, and other threads commonly used in tatting. Some are now longer available, but were pulled out of my stash of threads that I have from 40+ years of tatting and buying threads.

My problem with showing the full-range of threads I have in my spreadsheet are that I don’t know how to graphically publish them–I’m fairly Excel ignorant. I can figure out how to put the threads and numbers (yards/50 grams) into my chart, but can’t figure out how to export them into a usable graph. Can anybody help me with that? If so contact me at: k.bovard@yahoo.com or call: 402-960-7370 (I’m in Mountain Time Zone).

It’s really interesting to see how threads that we use relate to thread sizes of other manufacturers. The 20’s are fairly consistent/in the same size range but the 80’s are statistically different size-wise.

I use this chart to determine unique threads/fibers I find in such places as high-end yarn shops (specifically Personal Threads in Omaha, NE). Just recently I found & bought a skein of Indian silk lace-weight thread that I’m going to use for a new fiber-art venture I’m working on: Teneriffe Lace (More to come on that project.) The label said the skein was 800 yards per 100 grams. Thus, the thread/yarn is in the 400 yards/50 grams range and is very similar to Lizbeth 20 (both are slightly on the thicker-side of the 20’s range).