Complicated graph on Excel using Labview

[venkat1024]

Hello All

1. I am trying to plot some complicated graphs from some csv data file. I have been able to do this in excel using chart wizard. However, I want to automate this process using Labview. I am stuck at trying to plot a excel graph with primary and secondary Y-axis.I am attaching the project file and the relevant Vi. I am also attaching a same excel sheet which shows the finished version of the graph. 

2. I am also having trouble with formating the graph to make it similar to that obtained from excel.Specifically

(a) How do I place the legends at the bottom of the screen

(b) Also, how do to turn values on X-axis by 90 degrees and also display all discrete values instead of every 3rd or every 4th data point.

Vi - MOS_FUT_Display1_Attempt4.vi

data file in csv format - MOS_Scores_Generic_Overall_27Oct09.csv

original excel along with reference output formatting - MOS_Scores_Generic_Overall_27Oct09.xls

It is notnecessary for me to use excel to get my output, if I can use any other functions or vi to get the desired results, I am Ok with it.

Thanks a lot for your help.

Venkat

[nitad54448]

hi

sorry, this is not an answer, just another question...

i never use excel for graphs (and probably I'll never use, .. personally I am an Igor fun 🙂 ); however, why don't you use the graphing possibilities of Labview ?

N

[Harold_Timmis]

have you looked at the examples of excel that ship with labview?

[venkat1024]

Hey Harold

Thanks for your reponse. I did review all the examples provide for excel plotting. However, I couldn't find any example of using a secondary axis on excel. In my case, i want to add a line graph to an existing column stacked graph.

Thanks

 Venkat

[Kris D. · Accepted solution]

I'm not sure if this is the way you need to get to your outcome, but here is one solution.

[venkat1024]

Hey Kris

Brilliant and a simple solution. Thanks much!

Venkat

[64864050]

Hi, i saw ur comments with an attachment,

"

I'm not sure if this is the way you need to get to your outcome, but here is one solution.

Attachments:

MOS_FUT_automation.zip 32 KB

"

and i was wondering do u still have it? and can you change it the 8.5? as im using labview 8.5

if not could you take screen shot from me.

Im quite interested in your program on how u create MOS_Scores_Generic_Overall_27Oct09.xls

[64864050]

I'm not sure if this is the way you need to get to your outcome, but here is one solution.