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

Stacked cylinder chart

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
Kevin Buckland
Asked:
Kevin Buckland
  • 3
  • 3
  • 2
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
m4trixCommented:
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
 
Kevin BucklandInvestment OfficerAuthor Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
m4trixCommented:
How about something like this then?
 Stacked-Cylinder-Data.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
m4trixCommented:
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
 
Kevin BucklandInvestment OfficerAuthor Commented:
Thanks, I agree stacked columns is preferable.  I split the points though with m4trix.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
>> I agree stacked columns is preferable

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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