[SOLVED] Timescale chart interpreting dates wrong

[Jape]

I have a chart wich i want to display the complete current year. I want to populate this with dates with varying intervals (between, say 7 - 40 days).
When i fill the graph with 7 dates in Jan, Feb, and March, and change to timescale the dates seem to be plotted as months. Ive checked the number format. Whenever i switchh back to category it shows my dates correctly. How do i set it up so i can see the total year with the dates interval plotted on the correct dates ??

Jape,

 

[Jape]

Denis, thx for your help, your code does work, however in the end ive used an different solution by simply having an extra column aside my dates with the dates in 'excel serial format', Works great. Ill keep trying to do it in code, cause that must to be possible i think. Anyway thx for the help

Jape,