Results 1 to 2 of 2

Reform x-axis

This is a discussion on Reform x-axis within the Excel Questions forums, part of the Question Forums category; Hi, I have the following figure (version1) and I need to reform or shorten the x-axis to get the 100 ...

  1. #1
    New Member
    Join Date
    May 2015
    Posts
    1

    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
    2,887

    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)
    Read Forum Rules here

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