Results 1 to 3 of 3

Vertical axis numbering - cut out the middle numbers

This is a discussion on Vertical axis numbering - cut out the middle numbers within the Excel Questions forums, part of the Question Forums category; Hi all, I want to create a line graph with 2 series' data in it. The problem is the 2 ...

  1. #1
    Board Regular
    Join Date
    Feb 2005
    Location
    England
    Posts
    140

    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,388

    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,761

    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.

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