Charts-values

[Jithu]

Hi all,

I am plotting values rounded to 1 decimal place. The Problem is if the
values are very very small(0.01,0.02,0.03 etc) then the y - axis(which is
also rounded to 1 decimal place) is showing all values as .1,.1,.1 instead of
..1,.2,.3.....

Please provide a solution for the above problem..Thanks in advance for the
help and time.

Jithu

 

[Bob Phillips]

0.02 rounded to 1 dec place is 0.0 in my maths, why do you think it is 0.1
or even 0.2?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jon Peltier]

Think about what the axis values are, and how they are displayed. If the
major unit is 0.01, and the labels are limited to one decimal place, 0.00
through 0.04 will all appear as 0.0, 0.05 through 0.14 will appear as 0.1,
etc. You have to manually adjust the minimum, maximum, and major unit, as
well as the number format, in order to get the appropriate label appearance.

- Jon