Results 1 to 8 of 8

How to do a Stacked Column Waterfall Chart with a Secondary Axis

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    8

    How to do a Stacked Column Waterfall Chart with a Secondary Axis

    This is a complicated one...I know how to do a waterfall, I know how to do a stacked column, and I know how to add a secondary axis to a chart BUT, how do I do all 3 in one? Attached is a workbook that contains the pieces that I want to combine.

    Tab "Waterfall Template"--This is the waterfall template that I want to use. I currently am using the data I want for this chart but my columns are not yet stacked. Data is in rows 58-65.


    Tab "Gross Stacked Column Data"--Contains the data for the "Gross" set of data on the waterfall chart. As you can see, each bar is stacked with 2 categories "Operating NOLs" & "Stock Option NOLs". My waterfall chart is currently displaying the total data but not stacking by category.

    Tab "Tax-Effected Stacked Column Dat"--Contains the data for the "Tax-Effected" set of data on the waterfall chart. As you can see, each bar is stacked with 2 categories "Operating NOLs" & "Stock Option NOLs". My waterfall chart is currently displaying the total data but not stacking by category.

    Lastly, I want to add a seconday Y-axis on the waterfall chart for the Tax-Effected set of data. As you can see, it is on a different scale than the "Gross" set of data.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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