Strange behavior when copying ranges which include charts

BuJay

Board Regular
Joined
Jun 24, 2020
Messages
75
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
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....

1685819250834.png
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Make sure that the following option is checked...

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

2023-06-03_15-32-08.jpg


Hope this helps!
 
Upvote 1
Solution
Once again - Domenic saves the day! Thank you as always!
 
Upvote 0
You're very welcome, glad to help as always. :)

Cheers!
 
Upvote 1

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top