I have a typical financial data spreadsheet with data in in columns by month. I do a monthly dashboard for our board that shows things like liquidity, months of cash, etc. Every month I have to redirect the chart to select the information in the new month. So I was trying to find a way to have it automatically select the right most value in a range of cells so as I entered the new data it would automatically shift. Any ideas?