Labview Vs. Excel help in scaling

[krispiekream]

I currently have this excel page i created using labview.
and i am currently using microsoft excel page to scale it manually with the clicks of the mouse.

is there a way where I can automatically scaled it from labview to excel automatically?
please help
thanks

P.s- I am using labview 8.0 and used the activeX method to graph in excel


Message Edited by krispiekream on 11-14-2007 04:50 PM

[Donovan_B]

Hi krispiekream,

I looked on the Microsoft Developer Network website and located some methods that may help.   I found these on the Axis Object Members page, where it looks like you can change the maximum and minimum scale values, as well as set autoscaling.  I also ran across another forum post that shows how to get to these properties using ActiveX in LabVIEW.

Are you creating the Excel sheet in LabVIEW or just accessing it and changing values?  There may be different ways to accomplish this depending upon what your application is actually doing.  I hope this helps.

[krispiekream]

I have an XY graph.
the properties of the graph already have x-axis & y-axis, min and max.
how do i use those properties and apply it to my excel graph?
can someone please help me. my on going problem with this case is giving me such hard times.
thank you!

[Donovan_B]

You can access the x-scale min and max and the y-scale min and max using property nodes for the XY Graph.  Locate the XY Graph on your block diagram, right-click and then go to Create » Property Node » X Scale » Range » Maximum to get the maximum value for the X scale you have set in LabVIEW.  You can then expand this property node by clicking on the bottom of the property node and dragging down to create as many properties as you need and find the ones for minimum and the y-scale values (see below).  You will then need to use ActiveX methods to scale the Excel sheet using the values from the XY Graph property node.

Message Edited by donovanb on 11-20-2007 12:17 PM

[krispiekream]

yeah, i already have that part of the code on my program.
i just can't seems to figure out how to put those numbers in the activeX code.
does anyone?



Message Edited by krispiekream on 11-20-2007 12:31 PM

[Donovan_B]

I am not sure how to specify which axis you are setting the values for, but hopefully this will get you started.

Message Edited by donovanb on 11-21-2007 11:15 AM

[krispiekream]

it looks like what i am looking for.
can you attach the vi with it.
i am having a hard time trying to get _Chart with axes

[krispiekream]

ok. i got it. i'll try it out to see  if this will work. i'll let you know. thanks!