+ Reply to Thread
Results 1 to 2 of 2

Excel Chart, How to customize axis units as desired (not excel standard)

  1. #1
    Registered User
    Join Date
    10-16-2018
    Location
    turkey
    MS-Off Ver
    2018
    Posts
    19

    Excel Chart, How to customize axis units as desired (not excel standard)

    Dear All,

    I have a chart, min value 500 and max value 50000.
    I need to show y axis as:

    1000
    2500
    5000
    10000
    15000
    20000
    25000
    30000
    40000
    50000

    Is it possible?

    PS: My best solution is to use :

    primary unit as 1500
    lowest value is 500
    max value is 50000

    Thanks and all the best.

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

    Re: Excel Chart, How to customize axis units as desired (not excel standart)

    I'm not aware of any "built in" way to do this. The technique I would expect to use is to add a data series and use that series's data labels. See this tutorial for an application on the Y axis: https://peltiertech.com/Excel/Charts...cNotation.html and this tutorial for an application along the X axis: https://peltiertech.com/reciprocal-chart-axis-scale/
    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. Customize pivot chart axis
    By pezalmendra in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-06-2016, 03:53 PM
  2. How to change/customize the value of x-axis on an excel scatterplot
    By MiRoNYC in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-05-2013, 12:26 PM
  3. Change display units for y-axis (excel 2000)
    By maacmaac in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2010, 04:30 PM
  4. Mutliple major units in excel axis
    By karthikcoep in forum Excel General
    Replies: 1
    Last Post: 03-22-2010, 12:04 AM
  5. Line chart with multiple scales/units along an axis...
    By JohanD in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-19-2006, 01:00 AM
  6. defining major units on chart axis
    By Nick Turner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-31-2005, 03:05 PM
  7. [SOLVED] How do I customize the X-axis in excel to match my dataset?
    By cathy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-13-2005, 10:06 PM

Tags for this Thread

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