Hi there. Thanks for the reply.
But even after the chart is merged, unless you are equalising closes (which I'm not), then last week will be 'April', yesterday will be April, Today will be May, and going forward will be May?
p.s. the pivot points aren't a standard tool in the package I am...