GanttChart() available

I have uploaded the last version of the add-in that includes the GanttChart() function.
A new icon is included in the "Composition" group

At this time GanttChart() is only available for Excel 2007+2010 in the usual sparklines.xlam file.

I also uploaded a sample file so you can play with and report some bugs ... ;-)

Link to the add-in : http://www.box.net/shared/yqf4u9evib
Link to the sample file : http://www.box.net/shared/sxl6zog5k7zha0dhnhxa

Looking forward for some feedback...

When Mc Donald's tries in-cell charting

Here is what I found my french fries the other day @ Mc Donalds... in-cell charts ! Great !
At first sight , looks a good intention to provide easy to understand information, but... there is a but.

• What does the vertical reference dotted line mean ? 1/3 of the recommended daily amount ?... I guessed right !
• What does GDA mean ? Guideline Daily Amounts, sure, but I am in France, a country where 1% of  people understand English ;-)  ("I'm loving it" was properly translate however... marketing first !)
• What do those 2 icons in the center mean ( 4-7 + girl symbol) ? I had to check on Mc Do's website to understand that the daily amount displayed are in fact for a 4 to 7 year old girl... 
• What is the cryptic EU901.XXXX code doing here ? does this bring any info to consumers ? Nop.

Bottom line, good intentions, poorly delivered, this is what usually happens when marketing is dealing with data visualization. I think this info was clearly not meant to be read, even less understood.

Gantt Chart on its way

Just finished to put together a new UDF : GanttChart.

Pretty straight forward, this function displays tooltips when hovering over a task.

I am finishing some testing before uploading the new version SfE.

Here are the parameters for this function, only the first 4 are mandatory

ProjectStart As Date

ProjectEnd As Date

TaskStart As Date

TaskEnd As Date

TaskColor As String
TaskHyperlink As String
TaskTooltip As String
TaskCompletion As Double
CompletionLabel As Boolean
Today As Date
TodayColor As String
Deadline1 As Date
Deadline1Color As String
Deadline2 As Date
Deadline2Color As String
Deadline3 As Date
Deadline3Color As String
HitDate As Date
HitSymbol As Integer
HitColor As String