i have macro for line chart and getting markers on chart. how can i get thin line without any markers dots on it?
any idea?
thanks.
Please Login or Register to view this content.
i have macro for line chart and getting markers on chart. how can i get thin line without any markers dots on it?
any idea?
thanks.
Please Login or Register to view this content.
Last edited by oldhouse; 02-13-2018 at 09:06 PM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Before proceeding further in this thread, click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Now to your question:
You may add the following lines in your code to remove the markers.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
thanks
and sorry
thanks for quick reply
the macro is not working. i need to create line chart without markers for every sheet. range is A1:A250 and Q1:R250.
for some reason excel is not responding when i run the macro.
dont know how to solve.
It should work. Did you place the suggested For Loop just below the line which says End With? And place the line Dim ser As Series in the declaration section.
What do you mean by Excel is not responding? Does the application freeze?
yes it freeze
Does that mean, excel doesn't freeze if your original code creates all the charts and it freezes when you add the suggested code to remove the markers?
Can you upload a workbook in question?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks