Creating Excel Graph Using Report Generation Toolkit

[Zzimmha42]

Hello people,

I have a question regarding the use of report generation toolkit to create graphs in excel and was hoping that someone has possibly done this before. I've only been using the report generation toolkit for a little bit so I haven't quite figured out how to get too savvy when manipulating the data used. I'm currently creating graphs using 3 columns of data. The columns are acquired data consisting of 3201 data points, and a maximum/minimum spec line. The max and min spec line columns also contain 3201 data points, only 3 of which are non zero values. I was wondering if there was a way to ignore the data points that are "zero" and only graph the 3 non zero values from the max/min spec line columns along with the 3201 acquired data. Attached below is a screen shot of what I have going on right now. As you can see I have two lines set on zero for the entirety of the x-axis, except for the brief up/down tick where I have non zero spec values. Thank you in advance for any help!

[Gregory]

If you know exactly where those values are, I don't think it would be too hard. If not, you'd have to filter your data first to take out all of the x-y entries where y=0.

[Bob_Schor]

Am I correct that you've managed to make an Excel Workbook with data in 3 columns and 3201 rows?  Do you know how (in Excel, not in LabVIEW) to make the kind of graph that you are describing?  [I'm not sure I know, off the top of my head, how to do this, but if this is what I needed to do, I'd certainly "Ask Google" how to do it ...].

If you do know, you should be able to do something similar with the RGT in LabVIEW.  Tell us how to "do it in Excel", provide a data file, and I'm pretty sure one of us will be able to show you how to get the RGT to do it for you.

If you don't know, then you need to ask some Excel gurus for help.

Bob Schor