hey! thanks so much, i am going to have a play around with it and see if i can understand it...but it looks like it could definitely help me!! i'll let you know. i would also like to create a line chart which will show data up to that month so if i select november it will only show up to november. i may be able to work this out from your sheet though, thank you.