We have a spreadsheet that lists salespeople in A:A with monthly sales in columns to the right. Each month a new column is added. Salespeople come and go so the list gets longer as new salespeople are added. The X axis of the bar chart needs to be the list of salespeople and the series needs to be the last column (most recent month). I know this is a simple problem to solve but I can't figure it out.
Bar chart that only pulls last column of data