Exeel 2 y-axis in xline graph

[Mr. Robert]

Hi all,

I'm a fresh user using office toolkit.

I'm doing a project. I want to using office toolkit to draw a single graph in Excel but it has 2 different y-axis in 2 sides.

LHS is % Relative Humidity, RHS is Temp(degC)

They both have different ranges (%RH) range from 0 to 100%, degC from 0 to 50.

 Now I can present 2 data in seperate 2 graphs how about can LV 7.1 can draw the above data in single xlines graph?

Thanks. 

Regards,

Robert

[mikealder]

Drop the X-Y Graph on to the front panel then right click the scale of the graph, select "Duplicate Scale" With the second scale displayed right click one of them and choose "Swap Sides" you can now edit the upper and lower values for each scale.

To assign the two plots you need both plots showing in the Plot Legend box, right click Plot 0 and choose the Y Scale to be % Humidity then right click Plot 1 and set Y Scale to Deg C - Mike

[Mr. Robert]

HI mike alder ,

Thanks for your suggestion.

But I would like to plot the graph in Excel than in LabVIEW.

 Does you know how to set the same graph in Excel?

One other question, my data has total 30,000. points. As I call LabVIEW plot graph function. It's said LabVIEW only support 4,000.

Any solution?

Thanks.

Regards,

Robert

[Smootastic]

Hi Robert,

Have you tried the Append Front Panel Image to Report.vi?  This would paste an image of the 2 scale graph to your spreadsheet.  Also, I am sure LabVIEW will be able to support 30000 points.  What exactly are you trying that it says you can only use 4000 points?