+ Reply to Thread
Results 1 to 5 of 5

Combining bar graphs and waterfall graph

  1. #1
    Registered User
    Join Date
    08-18-2009
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    95

    Combining bar graphs and waterfall graph

    Attached is an example of what I'm trying to do. Can the variance year over year be shown on the same graph in "waterfall" style (i.e. stacked graph next to the standard bar)?

    I'm good with creating waterfall charts (see example). I'm just not able to combine it with the other chart data. Can doing all data in "Stacked Column" work (i.e. making the "padding" $0 for revenue 2013, 2014, 2015)?

    Thanks all for any help you can offer.
    Attached Files Attached Files
    Last edited by bluerog; 12-01-2015 at 08:49 AM.

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Combining bar graphs and waterfall graph

    I think that this site will give you what you want.

    http://peltiertech.com/excel-waterfa...bridge-charts/

    Jon Peltier is one of the best gurus on charting.

    Have a look at the post, and see if it applies.

    I hope this helps, please let me know!

    Regards,

    David


    - Please click on the *Add Reputation button at the bottom of helpful responses.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".


  3. #3
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Combining bar graphs and waterfall graph

    Hi bluerog,

    Just for fun, I had a bit of a play - I must stress, charting is not a strongpoint!

    This is what I came up with. It is a bid messy because I had to cut and paste each series into the chart, and re-format each data point to colour the bars.

    I hope this helps, please let me know!

    Regards,

    David


    - Please click on the *Add Reputation button at the bottom of helpful responses.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-18-2009
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: Combining bar graphs and waterfall graph

    Thanks much David. You rule.

    Organizing the data correctly and graphing all data with stacked charts is a perfect solution.

  5. #5
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Combining bar graphs and waterfall graph

    You are very welcome!

    And thanks for the Rep.

    DAC

+ 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 two graphs
    By ramsdesk in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-01-2014, 06:40 AM
  2. [SOLVED] Help with secondary axis on Waterfall Graph with 2 scenarios
    By Pi* in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-18-2014, 09:07 PM
  3. Combining a bar graph and line graph with 2 sets of data
    By lynzlou in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-11-2014, 12:49 AM
  4. Waterfall Graph
    By mudassirjaved in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-30-2014, 06:45 AM
  5. waterfall graph problem
    By jw01 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 01-28-2014, 10:48 AM
  6. waterfall graph issue
    By jw01 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-13-2013, 05:19 AM
  7. Replies: 1
    Last Post: 01-01-2012, 12:39 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