how can i chart data from the same cell on multiple sheets? when i enter
sheet1:sheet5!a5 i get a invalid reference error.