01-20-2010 06:31 AM
Solved! Go to Solution.
01-20-2010 07:55 AM
01-20-2010 07:55 AM
Hello pals,
I'm can't see all the problem because i ,don't have excel installed here. But you got two mistakes. Disconnect "Name" terminal from "excel get data"and "excel easy graph". That's not the terminal for the sheet name.
01-20-2010 08:32 AM
pals,
You have couple of minor errors in your vi. The first is that you wired up a string constant 'PSD' to the 'name' input of 'Excel Get Data.vi'. In this case the 'name' input refers to a named range which does not exist in the worksheet. Thus an error is generated and no data is retrieved from the worksheet. Since you are specifiying the start and end points, you don't need to connect anything to this input.
Second problem is that the string constant '01' you connect to the 'worksheet' terminal on 'Excel Easy Graph.vi' does not match the name of an existing worksheet in the workbook.
Third problem is that 'name' input on 'Excel Easy Graph.vi' again refers to a named range not found on this worksheet. Again, because you are specifying start and end points, you don't need to connect anything to this input.
Have attached modified version that creates graph in 'PSD' worksheet.
01-20-2010 09:27 AM
@ Wayne,
Thanks so much for all your suggestions. I tried still i am getting this graph and values of which i hv taken scrrenshot. May again i am doing some minor mistakes Both screenshot and my updated .vi file i am attaching... Thanks once again...
Pallavi
01-22-2010 04:26 AM
Hello All,
I got the solution only transpose vi is need to be added so you get correct graph...
Thanks all for rest suggestion I am attaching my Vi which is working properly.
Thanks...
Pallavi