LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Problem - move sheet and set axis of 2 plots (URGENT)

Hi,
 
I just realise that I post my problem in the wrong forum (http://forums.ni.com/ni/board/message?board.id=250&message.id=34834&jump=true). I need some help on Excel using ActiveX. I have 2 problems.
 
1. Move the sheet
I want to change the order of the worksheets. When I create a new Excel file, the order of the worksheet is Sheet1, Sheet2, Sheet3. I would like to change the order to Sheet2, Sheet1, Sheet3.
 
I have created a vi (attached below, in LabVIEW 8.20) but there is no change in the order of the worksheet. I guess I am missing out something. Could anyone give me some advise??
 
2. Set the axis of 2 plots
I want to have 2 plots on 1 graph, plot A and plot B. Both plots have different range of values on y-axis. Example, range of y-axis of plot A is 0-10, that of plot B is +/-5. I would like to change the range of y-axis to 0-10. This will means that I am ignoring any y value of plot B that is less than zero.
 
I hope anyone could give me some light on my problems. Thank you 😃
 
Regards
Lee
0 Kudos
Message 1 of 3
(1,117 Views)
Hi Lee,
 
For your first question, try it this way:
 
 
With regard to your second question, what have you tried so far?
 


Message Edited by JamesR on 11-14-2007 11:27 AM
Regards,

James R.
National Instruments
Message 2 of 3
(1,096 Views)

This is exactly what I was looking for. This was a tough one. Not much information out there that gets quite this specific. I have written a VI that includes this way of moving a sheet. I posted it on the Excel forum.

 

http://forums.ni.com/t5/BreakPoint/Excel-Board/m-p/1423044/highlight/false

 

Thanks,

Troy

0 Kudos
Message 3 of 3
(667 Views)