Deleting old data and pasting in new causes the series that use markers only to change to line AND markers.
0 views
Skip to first unread message
billyk0...@gmail.com
unread,
May 3, 2019, 9:45:20 AM5/3/19
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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?