Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the spacing of data markers in a line/scatter chart Nellyp Charts and Charting in Excel 0 July 27th 09 06:19 PM
Data Series Markers Wavequation Excel Discussion (Misc queries) 1 May 29th 09 10:27 PM
How to change color of line and point markers on a line graph SASPerson Charts and Charting in Excel 1 November 15th 06 06:43 PM
Too many markers on line chart makes it a thick line and individual markers cannot be seen denzel Excel Discussion (Misc queries) 2 August 2nd 06 04:06 PM
How to change the color of the series markers from yellow to Black Sam Charts and Charting in Excel 2 June 30th 05 02:47 PM


All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"