Ok, after messing it around for a little bit, it turns out I declared one of
my variables wrong, causing me to get the error.

Dim chartHolder As Excel.Chart ****WRONG****

it should've been

Dim chartHolder As Excel.ChartObject