Gantt Chart with autoshape as marker

[villy]

Hello Gurus,

I've been working lately with a gantt chart and having a simple challenge.
Here it is:

I have set of date (around 5 sets) start and end respectively. What I want is that in every week I want to insert an autoshape corresponds to the date specified.
For example:
1.) I have a dates in columns A:E as start dates and from columns F:J as end dates.
2.) In column K is week1, col L week2, col M week3, col N week4 (optional col O week5)
3.) I have a sets of autoshapes for ex. square, circle, diamond, etc. (whatever available) corresponds to each dates.
4.) Supposed I have a date 02.09.2011(dd.mm.yyyy) in A2, I want a shape (square) to be inserted in K2 as it is under week1. 12.09.2011 in B2 i want a circle for example to be inserted in L2 as it lies in week2 and so on...
5.) The challenge: If I change the date in A2 to 10.09.2011 then both square and circle should share a place in L2 as both of them lies in week2.

I know it is possible, I have tried using different symbols, wingdings to substitute for autoshapes but I'm getting lost.
I can provide more info if it isn't enough.
Thanks in advance for all your help.

Regards,
Villy

 

[villy]

Anyone with idea? Much appreciated.
Thanks