SOLVED

maintain scattered chart marker properties

Copper Contributor

Hi, 
When I copy and paste a scattered chart onto another one, the original marker style of the two initial charts is modified. I would like instead to maintain the original marker style of all the data sets in the final chart. 
I have tried the following option:

 

File > Options > Advanced > Chart >

deselect 'Properties follow chart data point for current workbook'

deselect 'Properties follow chart data point for all new workbooks'

But with no success (it seems to work with the "scattered with smooth lines chart" though).
Does anyone know an alternative technique to solve this issue?
Many thanks
Best wishes 

2 Replies
best response confirmed by Filips (Copper Contributor)
Solution

@Filips 

With your permission, I'm not an expert on charts.

But I know (even if I don't know anything) if you insert a file (without sensitive data) and explain your problem on this file, you will get an answer faster.

Notification of the Excel version and operating system urge you to get a precise answer.

 

Thank you for your patience and time.

 

Nikolino

I know that I don't know (Socrates)

 

@NikolinoDE 

 

Sorry for the very late reply, I will show you what I mean in the example attached.
Thank you for the advise

 

Filippo 

1 best response

Accepted Solutions
best response confirmed by Filips (Copper Contributor)
Solution

@Filips 

With your permission, I'm not an expert on charts.

But I know (even if I don't know anything) if you insert a file (without sensitive data) and explain your problem on this file, you will get an answer faster.

Notification of the Excel version and operating system urge you to get a precise answer.

 

Thank you for your patience and time.

 

Nikolino

I know that I don't know (Socrates)

 

View solution in original post