So I have recently been very enamored with the QVDesign Blog, my calendar activity ribbon

There are a ton of very nice, and cool designs here.

I was trying to figure out what I could do with a similar chart.

So I had the thought of what if I applied it to some sort of production. (We make frozen veggies) What would be really cool is if I could use the ribbon, and then if the user hovered over a block it would be able to popup the value, I messed with this for a while but never got anything satisfactory. If you wrap the cell text to 2 lines then it will do a popup. (Too bad it doesn’t popup if the data wasn’t fully displayed) So, maybe  Matt Crowther has an idea for this?? Also, I think it would be neat if there was a legend showing say six of the colors and the approximate values that they represent?

Anyways, so what I ended up going with is a ‘calendar activity ribbon’? I’m not convinced its useful, but at least its fun 🙂 It shows the last two months of production in a calendar format. Instead of going with weeks I went with the start of the week and end of the week, and then wrote formulas to suppress the days that don’t belong to that calendar. I also show the values in conjunction with the color coding.

So this is what it looks like.


One comment

  1. Hi Mike, This is very Nice.

    I am also trying this type chart (Calender Chart). But, I am not lucky. I had the Problem DayName (Sun, Mon, etc…).

    Can you please share the script and code for above one?


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 )

Facebook photo

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

Connecting to %s