Bar Graph

[DeanJo]

I am using VML to create a bar graph report, however i have run into trouble trying to come up with a formula to display and draw the grid lines by....

So if i have 3 users... 1 person does 10 time-outs, another does 20 time-outs and another does 24 time-outs....

The max result being 24 should be close to the top of the bar chart... so i would prob want to round to the next 5... i.e. the top of the chart being 25... first and foremost how do i round to the next 5, i will be only dealing w/ positive numbers...

[jhardman]

I am using VML to create a bar graph report, however i have run into trouble trying to come up with a formula to display and draw the grid lines by....

So if i have 3 users... 1 person does 10 time-outs, another does 20 time-outs and another does 24 time-outs....

The max result being 24 should be close to the top of the bar chart... so i would prob want to round to the next 5... i.e. the top of the chart being 25... first and foremost how do i round to the next 5, i will be only dealing w/ positive numbers...

say maxResult is your variable which now reads 24. You will always need to add one, right? (because if you started at 25 you would want the top of the graph to start at 30, not 25, right?) so add one, then start a loop that increments the number and exits when the number is a whole number multiple of five:

maxResult = maxResult + 1
do until maxResult/5 = int(maxResult/5)
   maxResult = maxResult + 1
loop

after your loop maxResult will be greater than the highest number you started with, and it will be the first multiple of five above your starting point. Let me kow if this helps.

Jared

[vikas000000a]

A better method to do it will be like this:

Suppose x is the variable in which your value is stored then:

 
if x Mod 5 <> 0 Then
       x = x + 5 - (x Mod 5)
End If
 

That's it. No loops required.

[jhardman]

A better method to do it will be like this:

Suppose x is the variable in which your value is stored then:

 
if x Mod 5 <> 0 Then
       x = x + 5 - (x Mod 5)
End If
 

That's it. No loops required.

That's a good solution. I never thought of subtracting xMod 5, but that should work, and very fast. Good job.

Jared

[vikas000000a]

That's a good solution. I never thought of subtracting xMod 5, but that should work, and very fast. Good job.

Jared

My pleasure, keep programming.