SnTT: Gantt Chart - Take 3
Bookmark :
It's a little early in the week for a SnTT post but I got inspired by Chris Blatnick and Theo Heselmans who recently blog about creating Gantt Charts and so decided to share with you how I do it.
My approach is similar to Theo's only a little easier, it involves using 'Show as Icon' columns but instead of having to create several graphics I only have one and repeat it a number of times according to the values.
Here's what it looks like, and the formula is below:
In the example I use a green graphic for percentages above 90 and a red for numbers below that.
If you're still reading, I have to let you know there is one drawback in this solution. If you mouse over one of the graphics you will see something like the image below. Not very pretty.
I will be experimenting with Chris's solution.
- 





Comments
Even if you remove the image resource name and leave only the alias it will still show you something like this ',,,,,' . Being able to remove the alt tag would be very useful.
Anyway, this has been a nice sharing exercise. Anyone else want to jump in and share their thoughs?
Posted by Vitor Pereira At 04:04:42 AM On 07/11/2007 | - Website - |
I think Theo's approach is probably better because each of the 10 image resources can be given a friendly mouseover name (e.g. "70-80%"), such that real information is conveyed by the mouseover (would be nice if you could just shut it off when you want, but alas).
Anyway, I threw my complete observations into a blog entry of my own here { Link }
Posted by Kevin Pettitt At 12:02:07 AM On 07/11/2007 | - Website - |