Sunday, January 7, 2018

Year in Pixels 2018 Mood Tracking Template

Year in Pixels is a cool idea I recently saw on Pinterest and decided I would make an Excel template for it to help save you the time of having to make your own using pencil and grid paper. Each day of an entire year is given one square or “pixel” and after every day you color in what your mood was for that day. It’s a great way to track your well-being to get a visual representation for how your year is going.

At the end of the year you’ll be able to answer the questions: How many days a year am I really happy or how many bad days do I experience in a year? Too many bad days in a row means it’s time to make a change.

During a day you may experience a wide variety of feelings. This chart doesn’t go that deep, it’s more what the culmination of everything is: was it a good day, an OK day, or a bad day?

The template is modifiable. You can change the colors if you want: I’ve decided to go with warm for happy feelings and cold for sad feelings. You can also change the number of colors/moods you want to track. I’ve gone with just five for now.

There are multiple sheets included within my template: a printable version, an Excel (electronic) version, and an example.

The printable version is for you old fashioned folks who want to print it out and color in the squares by hand with markers, crayons, or colored pencils. Feel free to hang it on the fridge or somewhere visible where you won’t forget to fill it out every day.



Personally, I prefer the Excel version because then I can do other things with it, like automatically sum up the total number of good versus bad days to know exactly what my percentages are.


See how easy it is to use the Year in Pixels template by watching the video below:



This template uses drop down lists, conditional formatting, and nested IF formulas. If you’re not sure what any of those are, I highly recommend downloading the sheet and taking a look at how it works.

Download Year in Pixels Excel Mood Tracker.xlsm

--Year in Pixels 2023 Update--

Happy New Year! I've made a few updates to the Pixel Year spreadsheet. First, I switched the format from xlsx to xlsm so I could add a macro. This way you can change the colors from the default to whatever you want at the click of a button. I also added a Yearly sheet so you can track your average and number of days for each category for each year and compare your years. See how I made the updates in the video below. Download link is the same.

 
Now you can track your mood in Excel with the Year in Pixels spreadsheet. Let me know in the comments below if you’re going to use it this year!

4 comments:

  1. Thanks for this! I looked for other charts online but I like your use of colors. I’ll be tracking my fitness and financial goals. We’ll see what it looks like a year from now!

    ReplyDelete
    Replies
    1. Thanks! I actually just updated it so be sure to download the new version.

      Delete

I'd love to hear from you!
-Nick