Create a 3D chart from a stacked bar and a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a 3 dimensional chart, based on a stacked bar chart. Specifically, I would like to give the individual elements of each stack different heights, in a 3rd dimension.

Forinstance:

Category A Element 1, Width 75, Height 10;
Category A Element 2, Width 25, Height 15;
Category B Element 1, Width 35, Height 5;
Category B Element 2, Width 65, Height 25;

For each category, elements 1 and 2 would be stacked to create a 100% bar (using the width); adding height is the challenge.

Any ideas would be most appreciated.
 
I don't understand what role width plays in the chart, but you might
want to see Funchrt4 and Funchrt5 at Stephen Bullen's site
(http://www.bmsltd.co.uk/excel/SBXLPage.asp#Charting). Whether one can
combine the 2 examples into 1 (if it even makes sense) and then add a
3D effect is something you will have to experiment with.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top