+ Reply to Thread
Results 1 to 6 of 6

Dual Waterfall

  1. #1
    Registered User
    Join Date
    02-18-2020
    Location
    Huntsville, Alabama
    MS-Off Ver
    Excel 2007
    Posts
    14

    Dual Waterfall

    I'm running into an instance where I know what I want my graph to look like, but have no way to get it there.

    What I have is two separate sheets, one for billing and one for expenses. The billing sheet has the date and the billed money totals, the expenses has the dates and cost for things ordered. I'd like to track each one on the same graph, with the X axis being the date. Each different line, the billing and expenses, should add up as the dates progress. It seems a waterfall graph would work, but I initially thought of a game flow graph on how it should look in the end.

    Either way I can't get any graph option to look like either of those options.

    Game flow.JPG
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Dual Waterfall

    From what you are describing I don't think you want a waterfall chart.

    Your sample image is a line chart. You need to add a column with running total to your data. See attached for implementation as a scatter chart with lines.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-18-2020
    Location
    Huntsville, Alabama
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Dual Waterfall

    Makes sense, since the basketball score is a running total itself. Got that to work, thanks.

    What I am running into now is getting the two lines to use their own dates. I can get the billing line to work, but once I put in the Expense line, it just uses the dates from the billing line.

  4. #4
    Registered User
    Join Date
    02-18-2020
    Location
    Huntsville, Alabama
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Dual Waterfall

    Scratch that, I figured it out.

    You can select a different X-axis series in Excel. But I was translating this into google sheets and sheets doesn't allow for multiple X-axis series. But a google search got me a work around.

    Thanks for your help!

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Dual Waterfall

    You're welcome! I don't use Google sheets much and don't know how its charting works. We have another subforum for Non-Excel worksheets--that's the place to ask a Google sheets question.

  6. #6
    Registered User
    Join Date
    02-18-2020
    Location
    Huntsville, Alabama
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Dual Waterfall

    I usually ask here first, as I end up using both. And if things don't work out I'll keep in mind that I can post in another subforum.

    Thanks again!

+ 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. Dual waterfall in MS Excel for Mac
    By knutolavklokk in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-03-2018, 10:37 AM
  2. Waterfall with dual bar start and end
    By mayhung in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-09-2015, 09:18 PM
  3. Waterfall Graph
    By mudassirjaved in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-30-2014, 06:45 AM
  4. waterfall chart
    By nicko54 in forum Excel General
    Replies: 1
    Last Post: 02-19-2010, 12:50 PM
  5. Waterfall within a waterfall
    By Drew Goldberg in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-31-2009, 07:50 AM
  6. [SOLVED] waterfall charts
    By Vlookup help in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-02-2006, 12:55 PM
  7. 3D Waterfall
    By Chase in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-07-2005, 05:05 PM

Tags for this Thread

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