ats

Thanks, this is really helpful and also the ideas you gave.

Atul

QUOTE(Doon @ Feb 21 2007, 11:58 PM)

I have built a simple "LVBA" application that opens excel, creates data, builds a chart and adds a second Axis.

It's a bit hurried, but I did take the time to annotate my code. :thumbup:

FYI, Atul, all VBA code written in LabVIEW ends up looking like that. I would normally break this sort of thing into a bunch of sub-vi's.

One thing I've done in the past was to build a template with the charts already properly formatted, etc., and simply add the data to spreadsheet. That worked out quite well, but took a great deal of time to tweak. I would suggest this sort of thing if you are using your code to generate a test data report.

I hope that helps

--H

I am trying to create an excel line chart with 2 Y axis, one on either side and was wondering if someone has tried it before. I have multiple channels to display as lines. The 'Excel insert graph.vi' in the report generation toolkit does not have "lines on 2 axis" graph.

I was told one can work with ActiveX or Macro's to accomplish it. As I have lot of data, Macro's may create issues. Also I tried to play around with Excel Set Graph scale.vi and mess around with ActiveX properties but couldn't find a way to do it.

I am using LabVIEW 8.0 on Windows XP machine. I will appreciate any help or suggestions in this regard.

Thank you,

Atul