01-23-2017 04:41 PM
Hey bfeddeck,
I'm not certain this is actually a change in the Excel 2016 type library, but I was able to get this to work using an array of string constants for the category names. Anything else threw an error, but once I made an array of strings and fed it into To Variant, that let me succesfully rename a chart's category labels. That should at least let you get something into Excel. As far as how to format the string so Excel parses as you need it to, I'm not sure, but see if this at least lets you write data into Excel.
Cason
NI Applications Engineer
01-24-2017 08:06 AM
I tried what you suggested (see attached) but I still get the error. Maybe I'm missing something. Can you post the vi you tried?