Stacked cylinder column chart with negative amounts

Posted on 2011-05-03
1 Endorsement
Last Modified: 2012-05-11
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
Question by:Kevin Buckland
    1 Comment
    LVL 50

    Accepted Solution


    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

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now