Typeerror 'buffer Size Mismatch' Error When Defining A Series In Xlsxwriter

I am trying to programmatically create a chart in an xlsx file using xlsxwriter and pandas data. Writing cells is succeeding fine, however when I try to define a Data Series for a

Solution 1:

The problem is that the name value headers['Bias'][h]isn't a string and raises a TypeError when passed to the function.

The error is a little more confusing than it should be due to the fact that the data type is a numpy.float64 which raises an unusual buffer size mismatch error.

The fact that the function parameters are spread over several lines also makes it look like the issue is with the values parameter rather than the name parameter.