Wanna hear somehtng funny ??

[ardneh]

Hi all,

I would like to create a line chart by using MsChart object.
So I created the array for 2 series, which the 2nd series will be the average value of the 1st series.. (so it is just a straight line).

Everything went fine and I was pretty happy .. but now, when I start playing with the program.. somethign strange happens.

when my average value falls below 0.1 , That means 0.01 - 0.09, the graph will draw the line on the 0 value !!!

Okay.. so you must be thinking, it's because the first series consits of big numbers so the scale is high..

Nope, totally not !.. the first series, is a value ranging betwen 0.01 - 0.05 !!

aaaaarrgggh.. then why in the world, the graph draws it at 0 value ??

So I entered the value 0.03 manually into the average values.
it appears at the 0.03 values
I entered, any values between 0.01 - 0.09... always appear.

But when I entered the value with formula into the this serie (the formula will result in a value of 0.028), again the average value is drawn at 0.

This is killling me .. I have a deadline tomorrow.. and there's this stupid but super annoying problem..

Help is badly badly badly needed...
Anyone .. ???





hendra wijaya

[DiGiTaIErRoR]

If you dimmed it as integer, it won't be a real number meaning it'll int all numbers taking away decimals and rounding.

Probably... if not then show some code.

Good luck,

[ardneh]

When I 'paused' the program and read the array where I stored the values... the value is stored as a double .
and not integer

Here is the part where I entered the value for the average series

'calculate the average
For i = 2 To lastRecord + 1
    x(3, i) = totWaste / totData / dividedBy
Next i
x(3, 1) = "Average (" & Format(totWaste / totData / dividedBy, "##,##0.00") & ")" 

x is an array which is defined as variant.

DO you have any other idea ?

Thanx anyway




hendra wijaya