Basically this exception occurs, when you add a chart, excel takes a default chart type and tries to match data in that default type and failed to create it.
I guess, you need to change that default chart type to some basic chart types (after adding that chart)
I’ll suggest you to follow solutions in the link below,