+ Reply to Thread
Results 1 to 6 of 6

Help with secondary axis on Waterfall Graph with 2 scenarios

  1. #1
    Forum Contributor
    Join Date
    03-17-2013
    Location
    USA, IL
    MS-Off Ver
    Excel 2010
    Posts
    121

    Help with secondary axis on Waterfall Graph with 2 scenarios

    Good evening,

    I am having trouble creating a secondary axis on the attached sample Waterfall chart to show the Gross Margin Variance - B/(W) range of data. I created the Waterfall Chart with minimal effort but my challenge seem to be with representing the GM Variance on a secondary axis (preferably the same column chart type) and also to be able to make the data ranges on the Y axis on the secondary axis should be such that the column/bar charts are the same size as that of the Revenue Variance bar charts created.

    I hope my request makes sense. Simply put; from the attached I am trying to create a secondary axis so that my bar charts in the Gross Margin section are the same size as those in the Revenue Variance section on the same graph if this is possible.

    I would really appreciate your direction and help.

    Best Regards.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Help with secondary axis on Waterfall Graph with 2 scenarios

    question
    your X-axis will not align with the 2nd group
    is that going to be an issue?
    Attached Files Attached Files
    Last edited by humdingaling; 07-18-2014 at 01:36 AM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Help with secondary axis on Waterfall Graph with 2 scenarios

    ps was wondering why your file was so big........

    your named ranges were the answer
    so i deleted them in my response
    file went from 1.3mb to 24 kb

  4. #4
    Forum Contributor
    Join Date
    03-17-2013
    Location
    USA, IL
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Help with secondary axis on Waterfall Graph with 2 scenarios

    Yes it is but Awesome! your help is much apprecaited.

    Thank you.

  5. #5
    Forum Contributor
    Join Date
    03-17-2013
    Location
    USA, IL
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Help with secondary axis on Waterfall Graph with 2 scenarios

    My apologies and Thanks.

    I appreciate your time.

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Help with secondary axis on Waterfall Graph with 2 scenarios

    sure thing
    yeah big files usually make the veteran members cringe and not download the file

    not a problem


    Cheers
    Hum

+ 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. How to do a Stacked Column Waterfall Chart with a Secondary Axis
    By Eric S in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-23-2015, 01:21 PM
  2. while creating a graph how to take secondary axis?
    By shilpa bvs in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-23-2013, 03:34 AM
  3. [SOLVED] Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis
    By Variablez in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-11-2013, 08:38 AM
  4. Replies: 4
    Last Post: 05-17-2012, 11:25 AM
  5. Replies: 0
    Last Post: 06-13-2011, 11:11 AM

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