HI

i have a chart linked to source data (10 days history with a number beside
each day) . I entered a worksheet formula to automatically show previous 10
working days - see below. Problem is the graph seems to recognise these are
dates and shows in the graph the weekend days even though these days are not
in the source data

any ideas?



=IF(WEEKDAY(A7)=2,A7-3,A7-1)
--
Kevin