+ Reply to Thread
Results 1 to 2 of 2

waterfall chart issue

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    waterfall chart issue

    all

    having some logic issue with the waterfall graph

    everything is working OK, except the variance btw 2018 to 2017 is showing the correct variance, however, the graph it not coming correctly?

    can someone pls assist....i dont know what logic to place in C8 or D8? see attached.

    thxs so much!
    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,803

    Re: waterfall chart issue

    I think you are correct that the logic in D8 is wrong (C8 looks correct to me). It looks like the value in D8 should be 678.50 -- the same value as is in C7. I am not an expert in waterfall charts, but it looks to me like the logic for D8 (and D6 and D10) should maybe be =MIN(C7,C9) where it will choose the smaller of the two rates for the years before and after.
    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. Waterfall graph issue
    By jw01 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-17-2017, 01:25 PM
  2. Waterfall Chart
    By JasonUK in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2015, 12:53 PM
  3. [SOLVED] Waterfall + stacked bar chart Excel issue
    By jw01 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-22-2015, 03:38 PM
  4. Waterfall graphing issue
    By jw01 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-05-2014, 03:33 PM
  5. Waterfall Chart - Adding text to chart from table
    By smudgepost in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-26-2014, 08:03 AM
  6. waterfall graph issue
    By jw01 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-13-2013, 05:19 AM
  7. [SOLVED] waterfall chart ... once again ...
    By SIGE in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 04-30-2005, 11: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