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
Thanks! Stacked-Cylinder-Data.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
ASKER
Thanks, I agree stacked columns is preferable. I split the points though with m4trix.
>> I agree stacked columns is preferable
This comment is worth more than any points. Thanks for the grade.
This comment is worth more than any points. Thanks for the grade.
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