If I were to have data in excel just like the table below, and then make line charts with that data. All is well and good until I have to come back around and add rounds 11, 12, and 13 to the data. If the 'Select Data' had Minutes and Cartons set as Series they would originally go from rows 2 to 11 in their respective columns, but since I added 3 new data points, I want the chart to automatically update to graph rows 2 to 14.
How do you get excel to do that on its own, instead of me having to go into the Select Data and edit every series every time?