Results 1 to 6 of 6

Help with secondary axis on Waterfall Graph with 2 scenarios

Threaded View

  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

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