Select YY and XX values from two columms and make a Chart

[Daniel Coelho]

Hi,

I have an excel file with two columms, one with temperature values and the other with the time of each temperature acquisition.

I want to programaticaly create a chart with those values, but when I input the range of the two columms the chart apears weird because the charts apears with two series of values instead of one series on the YY axis and time on the XX axis.

I have LabWindowsCVI 9.0. I'm using the function panel for excel reports. I also have the MS Excel Object Library function panel but I can't make sense of those functions.

How can I make the chart the correct way?

"find examples" has a perfect example of what I want but with the same problem... 

I apreciate all the help, it s an urgent matter.

Regards,

Daniel Coelho

[Steve__M.]

Hi,

What is your version of Excel ? Do you get an error message ?  Could you attach a screenshot of your problem please, it will be helpful for us to understand your problem.

Regards,

Message Edité par Steve Mohamed le 02-02-2009 05:20 PM

[Daniel Coelho]

Hi,

my problem is almost fixed.

The thing was that I wasn't able to create a chart with simply two colums, one with values and another with date/time string.

The graphic apeared funny because the date/time string was interpreted as another series of values, and I wanted the date/time on the horizontal axis.

I managed to do it by putting the horizontal values on the first colum and the actual values on the second colum and them I used the LabWindows function ChartWizard with one of the parameters using 'colums' instead of 'lines'...

I don't have any pictures to show because I never saved any data at that time.

So, now I can create a chart as I want, but when saving the workbook on one laptop with Excel 2007 (on VISTA) it works, but on another laptop with Excel 2003 (on XP) it doesn't.

I tryed to change the format when saving the workbook but then I can't save it on any of the laptops.

I get a negative error but I wasn't able to figure out the meaning of the error.

I will post the error as soon as I get my hands on those laptops again.

This was a bit vage but I 'm not currently working on the same thing.

[Steve__M.]

Hi Daniel,

Ok I'm waiting for your post, otherwise what's your version of Ms Excel object library? Please take a look at this thread

Regards,

Message Edité par Steve Mohamed le 02-06-2009 11:05 AM

[Daniel Coelho]

Hi. I read the post and my Ms Excel object library is 9.0, but I'm using ExcelRep.ort function panel from CVI 9.0.

I have everything working fine for me except one thing, on a laptop with XP, every time I execute my code the EXCEL process remains alive and after I run the code 10 times I have 10 EXCEL processes on the Windows Task Manager.

On my VISTA the process is killed, but on XP the process remains, how can I correct this?

[Steve__M.]

Hi,

Without your code it will be difficult for us to reproduce the problem and to see how behaves your code. It can be a bug or a certain something , so it will be very useful if you post it or a simplified version which reproduces the behaviour.

Best regards,

[Daniel Coelho]

Ok, here is my program attached.

It should run like this:

😆 LOG2EXCEL "PATH\File.LOG" "PATH\NewName.XLS" "PATH\XLSTemplate.XLS"

The first parameter is the program name

The second is the location of a LOG file

The third is the location of the new XLS fle that will be created

The fourth is the location of the XLS file to be used as a template for the new XLS file.

Don't mind the part where I try to manipulate a DateTime string, it is a bit messy because I was having a hard time using some functions. Just never mind that.

It is a bit of an urgent matter, so I apreciate your time on this.

Regards,

Daniel Coelho