Reform x-axis

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Reform x-axis

  1. #1
    New Member
    Join Date
    May 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Reform x-axis

     
    Hi,

    I have the following figure (version1) and I need to reform or shorten the x-axis to get the 100 closer to the 20.
    Why? Becasue I need to make the figure smaller and the whole distance between 20 and 100 is not needed as the change is linear.
    Any help.





    Thank you
    Taiseer

  2. #2
    Board Regular Worf's Avatar
    Join Date
    Oct 2011
    Location
    Rio, Brazil
    Posts
    3,041
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reform x-axis

      
    Hi and welcome to the Board
    I cannot see your picture. Anyway, you could use a broken axis, logarithmic scale or a panel chart. See this page:

    Broken Y Axis in an Excel Chart - Peltier Tech Blog
    Excel 2013 / Windows 8.1 (home)
    Excel 2013 / windows 7 (work)


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com