Combination Of Charts Creates Formatting Issues

[comp]

I am using excel 2013 and have run into an issue, any help would be appreciated. I am no wizard, but have basic understanding.
I have created a scatter chart that has multiple data ranges within. I could go back and add new data ranges for each new addition, but that would entail 14 data ranges, and a total of 2100 data points. time consuming.
So in order to speed things along i have found that if I copy/paste another chart onto the original it will import the new data ranges.
The problem is that when I paste in the new chart it messes up the formatting of the original data series. It changes the size of the icons, the color, and assigns a different icon to each data range. Very frustrating. I was wondering if there is a way around this?
I have included three illustrations below. The first is the original chart. The second is after copy/paste with the messed up formatting, and the third is after I have went back and reformatted the chart until my very eyes bleed. I need to do this to 15 charts each time....

\1
\1
\1


Chart 1.PNG
combined.jpg
desires.PNG

[comp]

I found a macro that works to change over a selected series, with a certain formatting. I know I could change the values to make it change the symbols to the dots I need, but unaware of which command to change the term "line" to. I know that changing weight would change the size, and then the color I would need to change to, but since it is a number I am not sure where there would be a corresponding chart that shows numbers for each color?


Sub x()
Dim objSeries As Series

With ActiveChart
For Each objSeries In .SeriesCollection
With objSeries.Format.Line
.Transparency = 0
.Weight = 0.75
.ForeColor.RGB = 0
End With
Next
End With
End Sub

[Andy Pope]

Post workbook rather than pictures.

[comp]

Thanks Andy. I have attached a few graphs that need combined, and then the end result. I could not attach the entire workbook it is too large but this should be enough to see the issue.
In the combined chart i have to go back and manually reformat those ranges, changing the color to a different color and back to size #2 round markers.

Example.xlsx

[Andy Pope]

Please Login or Register  to view this content.

[comp]

You are a genius, thanks a million!
...now only one more request. Is there any way that I could modify only the selected series, as opposed to the entire chart? This would allow me to create separate ranges of color, I have attached another workbook with the desired end result. sorry to be a pain..
Example.xlsm

[Andy Pope]

Please Login or Register  to view this content.

[comp]

You are the man! You have literally saved 8 hours a week of my time with this, unreal. Thanks again