I have a spreadsheet that reports 3 number results by quarter. I would like to create a pie chart that will only use the most current information. For example it will use quarter 1 data if no other quarter is filled out, but it will use quarter 2 data instead of quarter 1 data if there is a number in that cell. And so on until quarter 4.