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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kristen B - 06 Nov 2003 02:41 GMT

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.

Reply to this Message

Tushar Mehta - 06 Nov 2003 11:41 GMT

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.

Signature

Regards,

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

> 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.
>
[quoted text clipped - 8 lines]
>
> Any ideas would be most appreciated.

Reply to this Message