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.
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?