Yup looked at the file, looks pretty neat. Was something done in the RowSource sql to make it something like this or was it some sort of vba code? Could that somehow be replicated to suit my graph, by changing certain values (cycle time, total entries to show etc), while retaining the code that 'rolls' the week/month?