+ Reply to Thread
Results 1 to 3 of 3

Create this kind of graph

  1. #1
    Registered User
    Join Date
    09-17-2015
    Location
    Israel
    MS-Off Ver
    Excel 2010
    Posts
    72

    Create this kind of graph

    Hi,

    I have the following values:

    Type Min Max Difference
    A 0 0 0
    B 0 64.6 64.6
    C 64.6 3.1 67.7
    D 67.7 20.6 88.3
    E 88.3 11.7 100

    The chart that I want is attached. I would like to have a bar chart that Type B will start from the point where Type A is ending, Type C where Type B is ending, etc.
    For example, Type C starts at 64.6 and ends at 67.7... and so on.

    What I really want to do is to create that graph without having the columns Max and Difference, only Min as the column and the chart to be calculated.

    Any suggestion?
    Thanks.
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    06-30-2015
    Location
    Netherlands
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    145

    Re: Create this kind of graph

    delete wrong post
    Last edited by joris moerings; 10-10-2016 at 07:22 AM.
    HtH,

    Joris

    --------------------------------------------------------------------------------
    If you found my answer helpful, please hit the Like or Thank button.

    Please follow the forum Rules and Guidelines and use Code tags around your VBA code.

    Remember: test VBA code always on a copy of your file because usually you can't use undo

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

    Re: Create this kind of graph

    Your picture looks something like a waterfall or bridge chart. Here's a discussion on how to build these kinds of charts: http://peltiertech.com/excel-waterfa...bridge-charts/
    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. [SOLVED] What kind of graph is this?
    By Sgligori in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-25-2015, 11:44 AM
  2. how to make this kind of graph in excel
    By ijazali in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 12-15-2014, 07:49 AM
  3. HELP! Do not know what kind of graph to use?
    By akollman in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 10-24-2013, 04:32 PM
  4. [SOLVED] Second Axis for a Graph but with the same kind of graph for the two series?
    By Marceltcm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-18-2013, 05:37 AM
  5. Replies: 1
    Last Post: 02-20-2012, 03:13 AM
  6. How to plot this kind of graph???
    By ruzfactor in forum Excel General
    Replies: 1
    Last Post: 12-08-2010, 04:11 PM
  7. What kind of graph is used to show events over time
    By darbid in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-28-2009, 08:53 AM

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