+ Reply to Thread
Results 1 to 2 of 2

How to create histogram with unequal steps on y-axis, starting with 0 (followed by "jump")

  1. #1
    Registered User
    Join Date
    11-13-2014
    Location
    Paris
    MS-Off Ver
    2013
    Posts
    1

    How to create histogram with unequal steps on y-axis, starting with 0 (followed by "jump")

    Hi,

    I want to create a histogram in Excel 2013 where the intervals on the y-axis are not equal. To be more precise, the y-axis should start with 0, then "jumps" to another value and from that value on the distance between each point should be equal.

    Here is an example: http://i.imgur.com/iiQv6f9.png

    To make the diagram perfect, is it also possible to add the two lines which cross the y-axis (to indicate that there is this huge "jump")?

    It's a little bit embarrassing that I don't know the answer because I've created the diagram above with Excel 2003 several years ago. Unfortunately I cannot remember how I did it and I couldn't find any resources online (or maybe I just searched for the wrong terms).

    Thanks,
    Ole.
    Last edited by OleScheinfrei; 11-13-2014 at 02:05 PM.

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

    Re: How to create histogram with unequal steps on y-axis, starting with 0 (followed by "ju

    try searching for broken y 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. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  2. [SOLVED] Create a new workbook for every worksheet starting with "E" and password protect
    By Darth Raven in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2014, 09:12 AM
  3. Replies: 0
    Last Post: 07-08-2011, 02:25 PM
  4. How do you create a graph with 2 different "Y" axis?
    By peterwithingtonuk in forum Excel General
    Replies: 2
    Last Post: 06-24-2010, 05:31 AM
  5. [SOLVED] create links to check boxes marked "good" fair"and "bad"
    By pjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2006, 09:25 PM

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