Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charts for 2008 with No Values | Charts and Charting in Excel | |||
Zero values in charts | Excel Discussion (Misc queries) | |||
Charts and sub-values | Charts and Charting in Excel | |||
Zero Values in Charts | Excel Worksheet Functions | |||
Zero Values on Charts | Charts and Charting in Excel |