My Bipolar Mood Chart


This is the mood tracker I designed and use to track my bipolar cycle, I have split my mood analysis down to 3 flashpoints in the day (as I am a rapid cycler), with one commentary field for late evening. Late evening tends to be my flare up time and shows my true mindset.

Trust me this is not as scary as it looks, the key is as follows:-

  • Yellow bars – hours sleep for the night previous to date
  • Red line – morning feeling
  • Blue line – afternoon feeling
  • Green line – evening feeling

The system scores up and down feeling, 0 = normal feeling. -1 to -5 measures low mood, 1 to 5 measures high mood.





If you want to use this excel sheet, please Click here to download it. All graphs are auto-plotted from an input sheet, that could not be any easier.

The download currently covers December > February and I will upload it in three monthly chunks.  I have left the first day of each month populated to show you the graph in action, over type this with your own data.  Also remember to save each time you input fresh data, this will update the chart automatically.

If there are any questions, please feel free to ask.


47 responses

17 06 2008

I would love to see what the excel sheet for one of these looks like! It looks like you’ve put a ton of time and effort into this, and into your whole site for that matter – it’s very nice.

8 12 2008

If you could so kindly as to send me a copy of your Excel file for the above April moods chart, I would greatly appreciate it. I work with bipolar patients and this resource could be helpful for them. Thank you.

25 02 2009

I would greatly appreciate to have a copy of your excell file. I intend to translate it to portuguese and use it for myself. Congrats for this resource can help many bipolar people like me that lack the ability to create such a tool!
Thank’s a lot!

16 03 2009

have u heard of a site called moodtracker? its a place where u can chart your mood, even journal about specifics of moods t/o the day, triggers or whatever. Its cool cuz you keep track, and then you can print off your charts and bring it to the doc to show. There’s even an option for allowing your doc to access your charts online.

Just another option … love your website.

19 07 2009

Thank you for the spreadsheet. The graph part is really cool.

2 05 2010

is there a way to quickly change the dates column to the current date without having to do each individual box? I’m hot very excel saavy and I’m wanting to use this for my daughter (9 y/o) to keep track and be able to take to the dr visits. Great chart

29 06 2010

I am looking for a quick and easy mood tracker to keep for my two children. The oldest has been given a BP diagnosis and the 2nd has severe anziety and depression. Can I have a copy of your excell formating? I really like the look of this and it seems like an easy to impliment system.
Thank you so much for your time and hard work!
Melody ~

20 11 2010

it’s very nice.

15 10 2011

I was just diagnosed as bipolar 2 and am trying different meds after 30 days in hospital and would like to graph my moods. I am not able to download a copy of your excel graph. Please let me know how I can obtain a copy thanks

4 02 2012

Your graph looks great.
I was unable to download your Exel version to my computer.
I have page of several downloadable mood charts in pdf and doc formats at .


7 06 2012

Please email me with some pointers about how you made your website look like this, Id appreciate it.

21 06 2012

Re: Whomever produced the statement that this was a good web site genuinely needs to possess their brain looked at.

21 06 2012
high quality loan payday

I was wanting to know if you ever considered replacing the layout of your website? Its very well written; I really like what you have got to say. But maybe you could add a little more in the way of content so people can connect with it better. Youve got a great deal of wording for only having one or two images. Maybe you could space it out better?

23 06 2012

Hey, I just hopped over to your site thru StumbleUpon. Not somthing I might normally read, but I appreciated your views none the less. Thanks for making something worthy of reading through.

24 06 2012
18k gold earrings

If you dont mind, exactly where do you host your web page? I am hunting for a good host and your site seams to be quick and up most the time

25 06 2012
fx training

Heya, I just hopped over to your web-site through StumbleUpon. Not somthing I might normally read, but I enjoyed your views none the less. Thanks for creating something worthy of reading.

29 06 2012
rent how to achieve goals

Wanted to drop a remark and let you know your Feed isnt functioning today. I tried adding it to my Yahoo reader account but got nothing.

3 07 2012
visit budapest

This is often a amazing weblog, would you be interested in going through an interview regarding just how you developed it? If so e-mail me personally!

4 07 2012
scottsdale realty

Can you email me with any pointers on how you made your blog look this awesome , Id appreciate it.

4 07 2012
colocation services

Nice post . Thank you for, writing on this blog dude! I shall message you again! I did not realise that.

4 07 2012

Whenever I originally commented I clicked the Notify me any time new comments are added checkbox and currently every time a remark is added I receive 4 emails with the same comment.

6 07 2012

Awesome post . Thank you for, commenting on this blog page dude. I will email you again. I did not know that!

7 07 2012
athens weddings

When I open up your Feed it appears to be a lot of junk, is the issue on my side?

8 07 2012
best dentist in boca raton

I have got 1 recommendation for your webpage. It looks like there are a couple of cascading stylesheet issues when launching a number of web pages inside google chrome as well as internet explorer. It is functioning fine in internet explorer. Perhaps you can double check that.

8 07 2012
continue reading

When I start your Rss feed it appears to be a lot of junk, is the issue on my part?

9 07 2012
pip rebate

While I actually like this post, I think there was an punctuational error shut towards the finish from the third paragraph.

9 07 2012
cleaning porcelain tile

Wanted to drop a comment and let you know your Rss feed isnt working today. I tried adding it to my Bing reader account and got nothing.

10 07 2012
foreclosed land north carolina discussion

fairly useful material, all in all I picture this is worthy of a book mark, many thanks

10 07 2012
cosmetic dentistry nyc

You ought to really moderate the commentary listed here

12 07 2012
save on

A interesting blog post right there mate ! Thank you for the post .

12 07 2012

I like this blog site layout ! How do you make it!? Its so nice.

13 07 2012

Just to let you know your web site looks a little bit strange in Firefox on my pc with Linux .

13 07 2012
wine club

I love your wordpress theme, where did you get a hold of it?

13 07 2012
cheap brookfield wood blinds

Have you given any kind of thought at all with translating your current website into Spanish? I know a few of translaters here that would certainly help you do it for no cost if you want to make contact with me personally.

13 07 2012
red light camera san francisco

If you dont mind, where do you host your site? I am hunting for a good host and your webpage appears to be extremely fast and up just about all the time

14 07 2012
work from home site

This blog has lots of very useful info on it! Cheers for sharing it with me!

14 07 2012
buy quick payday loans no credit check

Just to let you know your webpage appears a little bit different in Safari on my notebook using Linux .

15 07 2012
rent cosmetic dentist in augusta

It seems to me that this website doesnt download on a Motorola Droid. Are other folks having the exact same problem? I enjoy this site and dont want to have to skip it whenever Im away from my computer.

15 07 2012
site link

Almost all of the comments on this particular website dont make sense.

16 07 2012
growing out gray hair

Have you given any kind of consideration at all with converting your main webpage in to Spanish? I know a several of translaters here that will would help you do it for free if you want to contact me personally.

16 07 2012

I like this website layout . How was it made? It is really nice!

16 07 2012
appstar complaint

Have you considered adding some relevant links to your article? I think it might enhance viewers understanding.

16 07 2012
patent pending

Wanted to drop a remark and let you know your Feed isnt functioning today. I tried including it to my Yahoo reader account but got absolutely nothing.

17 07 2012
printing in hampshire

Have you considered including some social bookmarking buttons to these sites. At the very least for facebook.

1 10 2012
Six thirty day period pay day loans

Hello, Neat post. There is a problem together with your site in internet explorer, may test this?
IE still is the marketplace chief and a good component to other folks will omit your excellent writing
due to this problem.

1 02 2013
peachtree sell annuity payments

I am extremely impressed with your writing skills as well as with the layout
on your blog. Is this a paid theme or did you customize
it yourself? Anyway keep up the excellent quality writing,
it is rare to see a nice blog like this one nowadays.

26 07 2013
cash advances

Hey this is kinda of off topic but I was wanting to know if
blogs use WYSIWYG editors or if you have to manually code with HTML.

I’m starting a blog soon but have no coding expertise so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: