+ Reply to Thread
Results 1 to 2 of 2

2 Scenario Waterfall Charts

  1. #1
    Registered User
    Join Date
    05-22-2020
    Location
    London
    MS-Off Ver
    365
    Posts
    1

    2 Scenario Waterfall Charts

    Hi, can you help me with a potential solution for this. I have a waterfall chart for a scenario with low impact and another for a high impact. Is there a way of merging these together
    Last edited by MyKIConsulting; 05-27-2020 at 11:48 AM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,809

    Re: 2 Scenario Waterfall Charts

    Short but useless answer -- yes, I am optimistic that they can be merged together. You have given no details about your spreadsheet or your charts to allow us to suggest anything specific, though.

    Your profile says you are using O365. Are you using the built in waterfall chart type? Or are you using the old fashioned stacked column or line chart type? My limited experience with these "specialty" charts in the latest versions is that they are relatively inflexible. Adding additional series or combining with other charts is often not possible for these specialty charts.

    From there, details probably depend too much on whether you are using built in specialty charts or standard chart types and how your data are arranged and what changes you are allowed to make. If you are using the newest built in specialty charts, someone else may be able to explain how to do what you want. If it is determined that the specialty chart is too inflexible, then you will need to build your waterfall chart using one of the standard chart types and go from there. If you are unfamiliar with these old fashioned methods, here's one tutorial: https://peltiertech.com/excel-waterf...bridge-charts/
    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. Combining Waterfall Charts
    By JPRICH16 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-01-2019, 10:55 AM
  2. how to make bridge charts (waterfall)
    By tantcu in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-04-2014, 12:14 PM
  3. Using PivotChart to create waterfall charts
    By springsteen87 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-24-2013, 04:31 PM
  4. Waterfall charts
    By EsKay! in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-30-2008, 11:54 PM
  5. Waterfall Charts - Automation
    By fritz78 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-24-2006, 02:45 PM
  6. [SOLVED] waterfall charts
    By Vlookup help in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-02-2006, 12:55 PM
  7. Macro - Creating Waterfall Charts
    By ddng in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2005, 06:31 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