XY graph in MS Office Report Express VI

[kpitt]

Hi,

I tried using MS Office Report Express VI with template as Custom Report (with a  *.xltx  template). But when i tried to insert a XY Graph (a 2D array with Row(0) as X axis values and Row(1) as Y axis Values) with 'Value Source' : Input ; and 'Input Appearance in Report ' :Graph;  onto the excel report, it shows a entirely messy output as shown below.

[Gregory]

I've not used that express VI, but it looks like you're graphing Y vs. Y.

[kpitt]

Hi Gregoryj,

Please see the new edit i made.The image i loaded initially was wrong.

[Gregory]

Can you upload the VI or a snippet of the VI so I can take a look? I'm using LabVIEW 2014.

[Bob_Schor]

Please attach your VI so we can see what you are doing.  For doing anything that is the least bit "unusual" (like inserting a Graph into an Excel Workbook), you should not use an Express VI.  It is really simple to create a Workbook with an embedded graph -- I posted an example here in the Forums a few years ago (I'll try to find it, but I think if you search for "Revised Example", it will pop up ...).

Bob Schor

P.S. -- note that what I was posting was a revision to an Example that came with LabVIEW.  I haven't looked at the currently-shipping Examples for RGT, but those would also be a good place to look for suggestions ...

[Matthew_Kelton]

Looks like you need to transpose the 2D array.

[kpitt]

Hi All,

Thanks for the inputs.

Please find attached the code and also the excel generated.

I actually wanted to get an excel sheet with both arrays and also the labVIEW graph of the same.
The only problem in the excel sheet is the messed up graph. I would want to get the exact same graph that i get in the front panel, on my excel too.
I tried Transposing, concatenating the array.. and all. Nothing worked.
Please help.

[kpitt]

Please find attached a version with the template file also attached. I forgot to attach the same before.
Please change the properties of the Express VI to map the template file and location to save accordingly.

[Matthew_Kelton]

Transposing the array fixes your problem.

[Matthew_Kelton]

Sorry, forgot to save my changes before I uploaded it.