+ Reply to Thread
Results 1 to 2 of 2

Is it possible to create an interrupted graph in Excel

  1. #1
    Registered User
    Join Date
    04-05-2021
    Location
    Belgium
    MS-Off Ver
    2019
    Posts
    1

    Is it possible to create an interrupted graph in Excel

    Is it possible to create an interrupted graph in Excel? By an interrupted graph I mean a graph similar to the picture.


    I already tried to make such a graph in Excel. I selected all data to create the graph and then made parts of the graph transparent. The problem is that the axis has several equal values. I would like only 1, 2, 3, 4, 5, 6 and 7 on the x-axis. The part graph between 1 and 1, 2 and 2, 3 and 3... I would like to make disappear. Is this possible? Or is there possibly another program I can use to do this?
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Is it possible to create an interrupted graph in Excel

    Short but useless answers -- Yes, this should be possible and yes, there are multiple charting/graphing applications out there that could do this just as well as Excel.

    It's difficult to be very specific with only a picture to work from. What I see in the picture is a line chart or scatter chart (I usually prefer a scatter chart). Perhaps two data series (one for the orange lines and one for the black dashed lines). In the spreadsheet, the data for the orange lines will have a couple of "gaps" and the "hidden and empty cell" setting will be set to "gap". Consider this data set:
    Please Login or Register  to view this content.
    A scatter chart based on that data would look similar to your picture.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Macro Hangs until Interrupted Excel 2016
    By GhostCookie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2019, 03:56 PM
  2. [SOLVED] How do I create a Graph in Excel like this?
    By ayro in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-30-2014, 12:10 PM
  3. Create Excel Graph
    By arun1985 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-12-2013, 08:15 AM
  4. Create Excel Graph
    By arun1985 in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 03-11-2013, 07:52 PM
  5. how can i create a bridge graph in excel?
    By Brian in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2005, 12:05 PM
  6. [SOLVED] How can I create a graph or something like a receipt on Excel?
    By Mrs S Rogers in forum Excel General
    Replies: 1
    Last Post: 07-21-2005, 02:05 PM
  7. Prevent Excel VBA Code from being Interrupted
    By Rajeev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2005, 05:06 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