Change line styles in an Excel graph

[AJL]

I am using the report generation toolkit in LabVIEW 2009 and need to change the line styles of three lines on a graph in Excel.  I found the property node that allows me to change the line style but I am not sure what to pass into the varient.  I have tried the name (ie xlDash) and the integer value (ie -4115) but neither seem to work.  Has anyone tried this and can offer some advice.

Thank you,

AJL

[The_Chancenator]

Hi AJL,

What property node are you using to change the line style?  Are you getting errors when trying to wire up the name and integer value, or does nothing change?  Are you using Excel 2003 or 2007? 

[AJL · Accepted solution]

I should have posted this sooner but I found my own solution.  I decided to read the properties from an excel graph and found that LV uses an integer thats value corresponds to where in the list in Excel the line style is.  IE continuous has a value of 1 since it is first in the drop down in Excel, Dash has a value of 2 since it is second in the list, etc.  One problem with this is that your code is  not very robust since the result can change if Microsoft changes the order of their drop down list in newer verisons of Excel. 

[The_Chancenator]

Hi AJL,

Thank you for the feedback and for posting your solution.

Cheers,