Paste Chart as Picture on worksheet

In Windows and on a Mac you can use this to make a picture of the active chart and paste it on the sheet

If you use the same code on a Mac it is possible if you have an older version of Excel it will paste the chart and not a picture of it. You can use the commented code below to avoid this problem if you have this problem, and it will work in Windows also.

If you have this problem replace
ActiveSheet.Paste
for
ActiveSheet.PasteSpecial Format:="Picture", Link:=False

23/03/2024
Web design by Will Woodgate