LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Generate MiniTab Graphs/Charts using Labview Data

Hi guys,

 

Since MiniTab can now take external data and generate graphs and charts from it, I thought it may be beneficial to pass this along to others that may want this functionality in one of their apps. The BD is wide and not optimized for speed but the code does work. By all means go ahead and make this your own and speed it up where you think you can. I am still working on what Commands need to be fed into the Project Node.

 

What this code does it it takes data from a 1D array and runs a RunChart and spits out a MiniTab chart in JPG format so you can paste this anywhere you wish. There are many other formats to choose from so go ahead and play with them. I’ve only played with the JPG format thus far.

 

By no means am I an expert as Labview coding or the MiniTab API. I'll help where I can but I may not get to in a timely manner. My company was working on a project using Excel data to MiniTab and returning reports back and thought I would try Labview and it works.

 

BTW, I am using MiniTab v17 and you’ll need to reference Mtb 17.0 Type Library. I am not sure of other versions have this (I think v16 does) so use at your own risk.

Message 1 of 8
(5,025 Views)

Hi Eric1977,

Your program very well, I have a problem now,I want to use the commands

to get a picture, including open a file, processing and save a

picture, such as run a macro command in the minitab window,how should I write

the labview program?  thanks.

the commands as shown below.

WOpen "E:\Minitab\Cpk-0708H00.csv";
  FType;
    CSV;
  DecSep;
    Period;
  Field;
    Comma;
  TDelimiter;
    DoubleQuote.

Capa '90V Turn On(T1)Ton 11VS' 100;
Lspec 255;
Uspec 280;
Pooled;
AMR;
UnBiased;
OBiased;
Toler 6;
Within;
Overall;
CStat;
 
gsave "C:\1.png";
PNGH.

0 Kudos
Message 2 of 8
(4,289 Views)

I am not sure how you should write it. How do YOU think you should write it? Try something and if you can't figure it out, start a new thread describing your problem.

 

As to the MiniTab report part...how I did it was I loaded the data I was going to use directly into MiniTab and just started played with what graph or chart I wanted until I got the desired output that I was looking for. Then I went into Show Histroy (CTRL+ALT+H) and looked at the code used to generate that Minitab chart/graph. Copy and Paste that into the ExecuteCommand "Command" Invoke Node (it expects a string) and you have a photo of your chart to do whatever you want to do with it. Remember, this is version 17 so newer versions could be different.

 

It looks like you have that down but I would try it with some known good data and run that just to make sure your graph or chart is what you desire.

0 Kudos
Message 3 of 8
(4,276 Views)

Thanks a lot!

I use your code to create a cool subvi and it can reduce almost 90% of manual work time into an automatic tasks while creating a CPK report.

0 Kudos
Message 4 of 8
(2,386 Views)

hi guys,

can you help me understand how to create an application in labview that recalls the functionality of Minitab?

I too need to create graphs for the calculation of Cp and Cpk and I would like to automate the procedure. What have to be installed on the pc regarding Labview and Minitab?......Are there any particular libraries?

thank you in advanced for your help

0 Kudos
Message 5 of 8
(2,295 Views)

Are you trying to automate the creation of the MiniTab charts via LabVIEW? Or do you want to just create a LabVIEW chart and just use the Cp and Cpk calcs?

0 Kudos
Message 6 of 8
(2,276 Views)

the first one.

I would like to use the features of minitab to create the graphs....not only Cp and Cpk but also histograms, time series graphs, etc.
I saw the example you shared, how did you create the reference to minitab?
I have installed Labview 2017 and minitab18

0 Kudos
Message 7 of 8
(2,242 Views)

How I did it was I placed a Application Refrum right on the Front Panel, then right-clicked, choose the Select ActiveX Class, then searched for, I think, it's MTB Type 17.0. Yours might be MTB Type 18.0. Then wire it up using the Automation Open ActiveX icon.

 

Eric1977_0-1652272681511.png

 

0 Kudos
Message 8 of 8
(2,226 Views)