Scatterplot values = 0

[PierreDFO]

I created and populated a spreadsheet using VB.net. When I try to scatterplot the data the x values look fine but the y axis values are recognized as zeros. I've checked and reformatted the fields, but no luck. When I try the same thing with another worksheet in the same workbook, everything works as it should.

[MrShorty]

A sample spreadsheet will probably be necessary. My first guess is that, for whatever reason, your VB.net code is entering the y values as text rather than numbers, and Excel is not able to interpret those text strings as numeric. I would probably start debugging this by using one of the IS functions http://office.microsoft.com/en-us/ex...632.aspx?CTT=1 to see what data type those y values are. If they are text, then we can work out how to get Excel to see them as numbers.

[PierreDFO]

MrShorty,
Wow a response. I haven't figured out how to send an attachment but here is an ftp link to the file.
Chart 1 was built using the Ambient Worksheet and Chart 2 Ambienttest. The problem occurs in the Ambienttest data...Plots are where I am heading...
ftp://starfish.mar.dfo-mpo.gc.ca/pub...TempTest1.xlsx
Cheers

[MrShorty]

Upon opening the file, the first thing I notice is a little green arrow in the upper left corner of each cell in columns A,C-I. I don't know what error checking options you have turned on and disabled, but this is Excel's way of highlighting a possible error -- in this case, the notification is, as I first suspected, a number stored as text. At this point, forcing Excel to perform some math operation will usually get Excel to convert these to numbers. Try putting 1 in an out of the way cell, then copy this cell, select the text values to convert, paste special -> multiply. Excel will attempt to multiply each cell in the destination by 1, which should convert numbers as text to actual numbers.

If this is going to be a frequent problem, you might look at your VB code to see if it can be adapted so that it inputs the values as numbers instead of text.

[PierreDFO]

Mr.Shorty,
I had the error checking set off in the options, so didn't see the flag. I had tried reformatting but I guess that doesn't wave the error. Looks like you got it, I'll fix my code...Thanks!