• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 439
  • Last Modified:

Stacked cylinder column chart with negative amounts

Can someone build an example stacked cylinder bar chart for me using the attached data?  

For each fiscal year I would like two cylinders: one for Principal and one for Earnings Reserve.  Within each cylinder I would like their respective components stacked. For Principal this would consist of Contributions/Appropriations & Unrealized Appreciation.  For the Earnings Reserve this consists of Realized Earnings & Unrealized Appreciation.  

Unrealized appreciation may be negative though so that eats away at the total balance.  

I'm having a hard time getting my chart to work  -- Thanks so much! Fund-Balances-Chart-Data.xlsx
Kevin Buckland
Kevin Buckland
1 Solution
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

You cannot have negative values showing in a stacked chart. Use a clustered chart instead to see the negative values.

Or, you could create a waterfall chart for each year, although some of the values are so small in comparison to others, that they don't show on the chart unless you define the Y axis to start at a large number (which distorts the chart)

See attached.

cheers, teylyn

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now