+ Reply to Thread
Results 1 to 4 of 4

How do I insert such type of graph?

  1. #1
    Registered User
    Join Date
    03-26-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2013
    Posts
    2

    How do I insert such type of graph?

    Hello,

    Im working on a research paper where i want to add a chart of cumulative savings and their cost, so that for each price it is clear how much of the savings can be done for that price (all below it). Attached is a sketch of which i mean. Data I want to use for the model are pairs of x1 and y1, savings size and price of the investment related to those savings (in ratio to savings)20140326_151613.jpg

    Greatings, Barry

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: How do I insert such type of graph?

    Looks like you want a Step Chart.

  3. #3
    Registered User
    Join Date
    03-26-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: How do I insert such type of graph?

    Thnx, looks kind of like what i need. However, filling there will fill entire graph. I found an example of a graph i want to recreate: excel forum.jpg

    Is it maybe an option to set a bar chart to have custom widths? so that bar has both x and y value?

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

    Re: How do I insert such type of graph?

    You can use a area chart and alternate data layout in order to create variable width columns

    http://www.andypope.info/charts/colwidth2.htm
    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. two type of graph in one chart
    By prityblossom in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-10-2014, 06:07 AM
  2. Graph for these type of data
    By bjelinski in forum Excel General
    Replies: 1
    Last Post: 09-13-2011, 06:32 PM
  3. What type of chart/graph do I need?
    By Burning Sensation in forum Excel General
    Replies: 5
    Last Post: 09-04-2010, 11:19 AM
  4. Change graph type
    By Steve in forum Excel General
    Replies: 3
    Last Post: 12-19-2005, 05:10 AM
  5. [SOLVED] Can you insert a graph inside another graph? if so how?
    By Jim Smith in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-08-2005, 11:05 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