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 BucklandInvestment OfficerAsked:
Who is Participating?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.