XL: Is this a variable type conversion error?

[mintjulep]

I have an XY chart. X values are in column A, with a column name in A1.

Cell A101 = 10

Since the array returned by activechart.seriescollection(index).xvalues
is 1 based, item 100 of the array for any of the series in the chart should (it seems to me) return the value of 10.

However, in the immediate window:

c = activechart.SeriesCollection (1).xvalues
? c(100)
 9.99999999999998

Same for any series, same value returned if referenced in code.

Can anyone tell me why this is, and more importantly, how to fix it?

 

[SkipVought]

Hi,


Is this a problem?

Is the value in A101 the result of a formula or did you actually enter the characters, one and zero?

Skip,

_[red][/red]

 

[mintjulep]

Duh!

Thank you.

In my defense, please note that it was past my normal bed time.