Thread: Deleting old data and pasting in new causes the series that usemarkers only to change to line AND markers.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] billyk07021974@gmail.com is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote