Is it possible to set the x axis of a vb chart to week numbers.
At the moment i set the x maximum to the current week number (as an integer) and the x minimum to the current week number minus 5 with an increment of 1.
Problem is that now we have passed year end i get negative numbers.
Eg. -3 -2 -1 0 1
Need 50 51 52 53 1
The base data (week numbers extracted from dates) i have stored in an SQL table.
All help most welcome