Hi everyone, I have 2 sets of data that I'm trying to display on the same chart. The first set has to be xlXYScatterLines data, which means there's a line between all my data points. However, I haven't found a way to display my 2nd data values without lines between my markers. Is there a way to do what I want?
If you are talking about the formatting of the series then either,
select the series and set the Line color to No Line Or select the series and change the chart type.
That's exactly what I want to do, but I can't find the required code to do it. I tried recording a macro while setting the line color to "No Line" on a data series, but the code doesn't show up somehow.
You may need to change the SeriesCollection index value, depending on what series you want to remove the line from.
Please Login or Register to view this content.
Thanks so much! You even guessed the SeriesCollection correctly :P
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks