+ Reply to Thread
Results 1 to 2 of 2

display unit on axis (unit that's less than 1)

  1. #1
    Registered User
    Join Date
    06-21-2016
    Location
    iran,tehran
    MS-Off Ver
    2016
    Posts
    1

    display unit on axis (unit that's less than 1)

    hi,
    i wanna set the display of "unit of axis" in a way that it shows them in micro units, one thousand units, etc. for example instead of having the axis numbers as : .0002, .0003,.0004, i want them to be displayed as 2, 3,4 and put a "X10^-4" in the axis corner.excel only has units which multiply by 10, 100, 1000, etc. but not the units that are less than 1.

    Thanks in advance!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: display unit on axis (unit that's less than 1)

    Unless it has been added very recently, Excel does not have good, built-in support for scientific notation like that. You will almost certainly need a helper column to compute the desired axis labels and then use a dummy series of some kind to get those labels onto the axis.

    Here is one possible approach: http://peltiertech.com/Excel/Charts/...cNotation.html I would suggest starting with this tutorial, understanding how it works, then modifying it to get the effect you want.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] I want to convert KB, MB, and GB to one unit so I can display a chart.
    By turtle328 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2016, 05:46 PM
  2. Replies: 4
    Last Post: 10-07-2015, 06:04 AM
  3. [SOLVED] Unit increase relative to variable unit thresholds
    By Fr3dle in forum Excel General
    Replies: 6
    Last Post: 07-01-2013, 06:57 AM
  4. Date Axis base unit smaller than 1 day?
    By emesgee in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-26-2013, 12:07 PM
  5. [SOLVED] [SOLVED] Time scale X axis with Major Unit of month
    By luvgreen in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-12-2006, 02:25 PM
  6. [SOLVED] Time scale X axis with Major Unit of month
    By luvgreen in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-12-2006, 11:05 AM
  7. Different unit distance on axis
    By Siberian in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-20-2005, 01:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1