1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Waterfall Chart Connectors

Discussion in 'Discuss Data Visualizations and Charting' started by Joseph Horling, Jun 27, 2018.

  1. Joseph Horling

    Joseph Horling Member

    Messages:
    56
    Hi Chandoo,

    I am practicing making waterfall charts. I'm not sure how to connect the up and down bars with lines. Can you look at the tab called Waterfall 6 and explain to me how I can do this? I connected the bars on waterfall 7 tab, but waterfall 6 is a different set up. Thank you Joe, Michigan.

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,632
    Your Waterfall 6 chart has an error
    B8 should be =B7-D8
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,632
    First Fix B8 and add a column for the value of each line
    H3: =G3
    H4: =H3+G4 copy this down

    upload_2018-6-27_23-33-48.png

    Now add a series to the chart as a Line Chart
    Then change the series to a Scatter Chart
    Then add a Horizontal Error Bar
    Format the error bar
    Set the Line to Scatter Line and markers to None
    Enjoy

    upload_2018-6-27_23-36-19.png

    or see the attached file

    Attached Files:

    Thomas Kuriakose likes this.
  4. Joseph Horling

    Joseph Horling Member

    Messages:
    56
    Thank you Hui, appreciate your help

Share This Page