I used to copy rows of data from one Excel 2013 workbook and then insert the copied data rows into another and all my chart ranges expanded as long as i inserted the rows within the rows already in the chart range but since Excel 365 the chart ranges no longer expand to accommodate the new rows of data....????
Solved by Z. S. in 27 mins