Solved

# Stacked cylinder column chart with negative amounts

Posted on 2011-05-03
438 Views
1 Endorsement
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
1
Question by:Kevin Buckland
1 Comment

LVL 50

Accepted Solution

Hello,

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
Copy-of-Fund-Balances-Chart-Data.xlsx
1

## Featured Post

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…