+ Reply to Thread
Results 1 to 2 of 2

Waterfall Chart--Going Negative

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    8

    Waterfall Chart--Going Negative

    Hi Folks,

    Attached is a waterfall chart that I created. You'll see that my "Variable 5" column drops the running rate of the waterfall chart below 0%. Excel is not allowing the bar to drop below 0%. Everything else on the chart is correct. My connector lines are even in the right position. Can anyone offer help on this? Thanks
    Attached Files Attached Files

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

    Re: Waterfall Chart--Going Negative

    If you go negative you need more series in order to span the gap. See this article for more information

    http://peltiertech.com/WordPress/exc...bridge-charts/
    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. Waterfall Chart
    By FM1 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-29-2013, 02:51 AM
  2. waterfall chart
    By nicko54 in forum Excel General
    Replies: 1
    Last Post: 02-19-2010, 12:50 PM
  3. Waterfall chart
    By wjviveen in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-25-2009, 10:18 AM
  4. [SOLVED] waterfall chart ... once again ...
    By SIGE in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 04-30-2005, 11:06 PM
  5. negative waterfall chart
    By Pablo in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-27-2005, 06:06 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