Cross-Stitch Viz Art
I was working on a scatter plot and trying to determine which shape made it easiest to read. I switched to little x’s and thought it was so cute. It looked just like cross-stitch! It made me think, it wouldn’t be that hard to replicate cross-stitch in Tableau, right?
So here it is:
It was actually pretty easy to do. It only took me like 20 minutes or so, and most of that was just drawing it.
I set the width/height of the cells so that they were basically squares. Then, I started coloring in cells. Pretty self-explanatory.
Step 2: Make sure everything has a coordinate.
I numbered all the rows and columns so that there was basically a coordinate system for each cell.
Step 3: Replace cell colors with labels.
Did you know you could do a find and replace based on formatting? It’s true! I searched for all the colors I used and replaced them with a code: blk, blu, or red.
Step 4: Reshape.
The way the data is shaped right now couldn’t go directly into Tableau. I used the Tableau Reshaper tool to turn each colored cell into a color and a pair of coordinates.
Step 5: Bring it into Tableau
Put your x values on columns, y values on rows, color on color, and change the shape to x’s. BAM! You now have cross-stitch. Because of the way I numbered the y-values, it ended up being upside down at first. I reversed the y-axis and that was it! Done!
Would this ever be useful? Probably not really. I’ve read online that a lot of people design cross-stitch patterns in Excel, though, and this may be a good way to quickly change colors and decide on what you want the final product to look like. Mostly, it was just fun for me because I generally think of myself as a crafty person but I’m terrible at doing cross-stitch in real life.