Vertical axis numbering - cut out the middle numbers

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

Thread: Vertical axis numbering - cut out the middle numbers

  1. #1
    Board Regular
    Join Date
    Feb 2005
    Location
    England
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vertical axis numbering - cut out the middle numbers

     
    Hi all,

    I want to create a line graph with 2 series' data in it.
    The problem is the 2 series are very different in number range. Series 1 ranged from 60-180 and series 2 ranges from 0-10.

    because the graph needs to be reasonably small, series 2 can barely be seen.
    Is there a way of cutting/hiding 11-59 from the graph and then expanding 0-10 to take up space made by removing those numbers?

  2. #2
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    15,473
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Vertical axis numbering - cut out the middle numbers

    You could use a logarithmic scale on the Y axis (very easy).

    You could create a secondary Y axis (very easy)
    Add or remove a secondary axis in a chart

    You could make a panel Chart (easy)
    Panel Chart

    Or you could create a broken Y axis (hard)
    (Do a web search for something like Excel Broken Y axis for a few tutorials and examples.)
    Paste your Excel data to the forum...
    MrExcel HTML Maker or Excel Jeanie

    How to post your vba code
    [CODE]your VBA code here[/CODE]
    The # button in the forum's editor will apply CODE tags around your selected text.

  3. #3
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    18,955
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vertical axis numbering - cut out the middle numbers

      
    Hi

    For the broken Y axis see Andy Pope's solution:

    AJP Excel Information

    but first check Jon Peltier's "Panel Chart" link in AlphaFrog's post to see that a panel chart may be a better solution.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

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