histogram for each row in a it's own spreadsheet

[achfire]

Hi

i want to get a graph and a histogram for each row that i get in a different page of the same workbook,what i have to change to get that

and for the histogram,i want it for the purpose of comparison,so it has to show me the value of each row compared to the average value of all the rows of the table

[achfire]

Hi

i want to get a graph and a histogram for each row that i get in a different page of the same workbook,what i have to change to get that

and for the histogram,i want it for the purpose of comparison,so it has to show me the value of each row compared to the average value of all the rows of the table

[LindyHop]

Hello achfire,

What exactly are you trying to do? Are you reading from an excel spread sheet or are you writing your own spreadsheet in LabVIEW? What is the Table Control for? 

The example you are building off already takes in a spreadsheet from Excel. That data is located after the "Excel Get Data" VI. Once you have a 2D array in LabVIEW you can parse it however you'd like and create the histograms for each column or row of data. 

If your data is on multiple sheets in Excel than you may find this useful. Either way, once the data is in LabVIEW you'll need to do some array manipulation to parse the data the way you want it and plot it correctly. 

[achfire]

no i want to write in the spreadsheet,as you've noticed,each row goes to it's own page of the same workbook.i need now to get a histogram for each row in excel

[achfire]

is it impossible to get a histogram wich contains values from a row near the average of all the values of all rows to make comparison

[LindyHop]

Is there a reason you're trying to do this programmatically in LabVIEW? Maybe I don't understand what you want to do, it sounds to me like you have:

1) Data in Excel

2) Which you want to bring into LabVIEW

3) And then use to programmatically make histograms in Excel

Is that the correct gist of it? If it is, do you mind explaining why you're using LabVIEW? It seems like it would be much easier for you to make the histograms in Excel and use Excel Macros to make it simpler. 

If you need to use LabVIEW as an intermediary step then you'll have to use ActiveX controls to manipulate the excel environment. 

[achfire]

i get the table after a lot of steps with labview,then i want to export this table to excel,but not in any way.each row of the table that i have in labview,i have to get it in it's own excel spreadsheet of the same workbook,i solved that problem.now i want to have in front of each row in excel it's own histogram,but that histogram has to contain the values of that row near of the average of all the values(values of all columns),like this picture

[achfire]

Hi everybody

i made some change in my VI, and it's nearly done.

the only thing that i need now is how to make that table which contains 1 row fancy ,and avoid to get it in the 1st row of the spreadsheet, i think i have to change append  table to report vi to another vi,if someone has any suggestion i'll be really grateful

thanks