And for those without excel or can't be bothered to download files here is a screen shot of pivot chart. please put forward your thoughts or ideas. There may be something in this.