Strange behavior when copying ranges which include charts

[BuJay]

I have a chart with series data in cells B1:B10. The chart itself is in cells D5:J20. When I copy the entire columns from column A through column K, and then I move to sheet 2 and paste into column A, the series data is pasted in cells B1:B10 but the charts are not pasted.....in fact, if I columns A through K and attempt to paste them into the same sheet into columns N through X, the data shows up in column Q but the chart is not pasted....I would expect the chart to show up in the shaded location when I paste from the clipboard.

Wondering if someone can tell me what's going on there.....is it a global setting? or a copy option? I have performed this same series of steps for years and never had an issue....

 

[Domenic]

Make sure that the following option is checked...

Ribbon >> File >> Options >> Advanced >> Cut, copy, and sort insert objects with their parent cells

Hope this helps!

 

[BuJay]

Once again - Domenic saves the day! Thank you as always!

 

[Domenic]

You're very welcome, glad to help as always.

Cheers!