Make pivot charts bitmap and replace original

I have a bit of code that saves down a copy of my workbook (static version), makes all of the values static but I also want the pivot charts to be static.

I need to make the chart a bitmap, put it where the live chart is, and then remove the live chart.

Could someone please help me with this code?

Thanks