Force decimal in graph axss

[rzito]

I am having a issue when I try to programmatically apply the X axis to
my chart as I am trying to chart against a double number (ie: 45.89)
should be part of the X axis, I keep getting an error that I can not
use a decimal, is there a way I can force it in? I put labels under
the chart but sometimes depending on the source data the chart expands
and the values no longer lines up, thanks!

[engles]

On Mar 26, 6:41 pm, [e-mail] wrote:

I am having a issue when I try to programmatically apply the X axis to
my chart as I am trying to chart against a double number (ie: 45.89)
should be part of the X axis, I keep getting an error that I can not
use a decimal, is there a way I can force it in? I put labels under
the chart but sometimes depending on the source data the chart expands
and the values no longer lines up, thanks!

I'm not sure exactly the problem, but to get double and integer, try
using cdbl(clng(x)) where, x is a double. The clngconverts to
integer, then cdbl converts back to double. That might solve your
problem.

-- Larry Engles