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