Martin:
After reading your post, I was able to duplicate the problem you
describe. I hadn't really noticed it before because I always
poke my data into Excel in numerical (floating point) format.
If you wire a 2D array of floating point values to the "value"
property of the Range object, this problem does not occur. But
if you wire a 2D array of strings, the Y column is indeed not
plotted. Apparently, Excel still considers the data to be
text. You can see this if you change the cell formatting to
numerical and set the number of decimal places. The values in
the cells will not change the number of decimal places showing.
They will also be left-aligned in the cell by default, a sure
indication of text; numerical data is right-aligned. Evidently,
Excel plots X text valu
es (because they are sometimes months,
categories, etc.) and not Y text values.
One of the ways I found you can convert the cells is to select a
column and choose Data>>Text to Column from the Excel menu.
This will convert the text values to numerical format. Another
way to avoid the problem is to pass the Labview Data to the
workbook in numerical format rather than as strings. I am sure
others here probably have different ways of converting the data
using ActiveX. Perhaps they will share. Anyway, hope this
helps.
MaxMar
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!