Deleting old data and pasting in new causes the series that usemarkers only to change to line AND markers.
 

I have an Excel 365 workbook with 18 charts. I have a macro that deletes all the old data (but not the headers) and pastes in new data.The number of rows of data varies, but the number of columns stay the same. Whenever I do this the series that use only markers are changed to markers AND lines. How do I prevent this change?

Thanks,

Billy