Solved

Stacked cylinder chart

Posted on 2011-05-10
1,443 Views
I need the attached data put into a stacked cylinder chart.  I need one cylinder for principal and another cylinder for 'earnings reserve' for 3/31/10; duplicated cylinder presentation for the same as of 3/31/11.

Thanks! Stacked-Cylinder-Data.xlsx
0
Question by:Kevin Buckland

LVL 50

Accepted Solution

Hello,

you can use a clustered stacked column chart for that. The attached chart was created following the steps in this tutorial
http://peltiertech.com/WordPress/clustered-stacked-column-charts/

A 3D effect with cylinders instead of columns is not as versatile and will not work with this technique (the x axis labels will not show properly). In any case, a 3D chart obscures data rather than highlights it and is never a good choice.

cheers, teylyn
Copy-of-Stacked-Cylinder-Data.xlsx
0

LVL 7

Expert Comment

Can you elaborate how exactly you want the charts?
one for each year showing a column for principal and another column for earnings reserve?
one for principal showing a column for both years, and one for earnings showing a column for each year?
something different?

I threw together the following, but I don't think it's what you're looking for:
Stacked-Cylinder-Data.xlsx
0

Author Comment

m4trix:
I was hoping to have the two cylinders (principal & earnings reserve) side-by-side on one chart for 3/31/10; and then in another chart have the two cylinders for 3/31/11.
0

LVL 7

Assisted Solution

How about something like this then?
Stacked-Cylinder-Data.xlsx
0

LVL 50

Expert Comment

AMHTA, can you see why cylinders are not a good choice? At which number does the high light red cylinder end? Even worse with the short cylinder. It does not even touch the grid lines. It's impossible to even estimate the approximate value with a cylinder chart.

Compare the same charts as stacked columns. Here you can see how the cylinder height relates to the Y axis values.

See attached.

cheers, teylyn
Copy-of-Stacked-Cylinder-Data-2.xlsx
0

LVL 7

Expert Comment

teylyn, I had the same thoughts. It was tough to figure out what the value was for each column. I tried putting the values on them, but that didn't work out at all
0

Author Closing Comment

Thanks, I agree stacked columns is preferable.  I split the points though with m4trix.
0

LVL 50

Expert Comment

>> I agree stacked columns is preferable

This comment is worth more than any points. Thanks for the grade.
0

Featured Post

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.