+ Reply to Thread
Results 1 to 2 of 2

Varying scale on the Y-Axis

  1. #1
    Registered User
    Join Date
    07-15-2020
    Location
    London
    MS-Off Ver
    2006
    Posts
    1

    Varying scale on the Y-Axis

    Hi there, I'm trying to trace a graph on excel but it has a varying scale on the Y-axis, shown below:

    Annotation 2020-07-15 142030.png

    As you can see, it goes from 100 --> 1,000; then 1,000-->10,000

    Is there any way to achieve this scale on excel?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Varying scale on the Y-Axis

    The vertical axis can be set to Log base 10.

    I'm guessing the horizontal axis is a category axis
    Cheers
    Andy
    www.andypope.info

+ 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. Scale on horizontal axis on a graph with secondary vertical axis
    By selsaid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-06-2019, 07:54 AM
  2. Replies: 1
    Last Post: 11-06-2019, 07:30 AM
  3. Replies: 3
    Last Post: 04-09-2018, 10:42 AM
  4. Replies: 2
    Last Post: 10-08-2014, 08:04 PM
  5. Secondary axis not picking up amended data for axis scale
    By AileenR in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 10-02-2013, 06:17 AM
  6. Creating a non linear x axis/ varying scale
    By richjh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-08-2007, 05:01 PM
  7. [SOLVED] How to insert X axis scale values next to axis and X axis grid lin
    By vp23larry in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-23-2005, 11:05 AM

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