Thread: Charts-values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Charts-values

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jithu" wrote in message
...
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