Results 1 to 3 of 3

Chart type & how to make

This is a discussion on Chart type & how to make within the Excel Questions forums, part of the Question Forums category; Hi, Can someone tell me what kind of chart or graph this is & how to make on in excel? ...

  1. #1
    Board Regular
    Join Date
    Jul 2010
    Posts
    60

    Default Chart type & how to make

    Hi,
    Can someone tell me what kind of chart or graph this is & how to make on in excel? I call it a step chart because it is supposed to show the series of steps taken to result in the final value - kind of like the credits & debits in your checkbook that result in your bank balance. The picture refuses to copy correctly - the -20 should be twice as tall as they are and the +10 is not supposed to be underneath the -20, it should be next to it.

    +10
    +10 -20
    +10 +10
    +10 -20
    +10

    Thanks in advance.
    Last edited by fangfacekitty; Oct 10th, 2016 at 04:38 AM.

  2. #2
    Board Regular
    Join Date
    Jan 2014
    Location
    Pittsburgh
    Posts
    496

    Default Re: Chart type & how to make

    I think you want a waterfall or bridge chart.

    Waterfall charts are available as a built-in type in Excel 2016:

    https://support.office.com/en-us/art...7-546f5527f185

    To create them in earlier versions of Excel, try these tutorials:

    http://peltiertech.com/excel-waterfall-charts-bridge-charts/

    http://www.contextures.com/excelwaterfallchart.html

  3. #3
    Board Regular
    Join Date
    Jul 2010
    Posts
    60

    Default Re: Chart type & how to make

    Great, this is exactly what I was looking for. Thanks!.

    Quote Originally Posted by thisoldman View Post
    I think you want a waterfall or bridge chart.

    Waterfall charts are available as a built-in type in Excel 2016:

    https://support.office.com/en-us/art...7-546f5527f185

    To create them in earlier versions of Excel, try these tutorials:

    Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog
    http://www.contextures.com/excelwaterfallchart.html

Tags for this Thread

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