Hi!

I'm trying to create a chart that includes a weekly scale on both X & Y
axis.

The format required is as follow: YYwkWW - i.e. 06wk52.

My issue is that after 06wk52, the 07wk01 corresponding value is shown
on level 01 of the y axis (cells are formatted to respond to format
requirements), or there is a gap of 48 between 06wk52 and 07wk01 if a
calculation is applied.

Anyone seen this before???

Cheers for your help!!!

JF


--
JFAIRBUS
------------------------------------------------------------------------
JFAIRBUS's Profile: http://www.excelforum.com/member.php...o&userid=35932
View this thread: http://www.excelforum.com/showthread...hreadid=557253