3D Stacked Column Chart
 

Hi Team,
I know how to do 2D stacked columns and separate 3D Column carts but I want
to do a 3D Stacked column chart ie. 4 variables. I've explored links on
similar discussions but have seen no example.
I recognise the detrimental presentation risks on a 2D printout.
Could you please advise?
Thank you,
Ditch

3D Stacked Column Chart
 

It's not so much "detrimental presentation risks", it's detrimental
comprehension risks. The chart will be difficult to read and impossible to
understand. It's possible to build such a chart, but it requires you to
build multiple 2D stacked columns with 3D effects, make them selectively
transparent, and align them in layers. It's a pain to build and to maintain,
and it's a pain when someone gives you one to interpret.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ditch" wrote in message
...
Hi Team,
I know how to do 2D stacked columns and separate 3D Column carts but I
want
to do a 3D Stacked column chart ie. 4 variables. I've explored links on
similar discussions but have seen no example.
I recognise the detrimental presentation risks on a 2D printout.
Could you please advise?
Thank you,
Ditch

3D Stacked Column Chart
 

Thanks Jon,
We are aware that the stacked columns inside the outside stacks will be
obscured. We are wanting to see how the overall profile changes as we
selectively remove or add series to within the stacked columns across the
three other variables. The edges will also be of interest. It seems as
though there is no simple 4 data column solution on this occasion.
Thanks for your advice,
Ditch

"Jon Peltier" wrote:

It's not so much "detrimental presentation risks", it's detrimental
comprehension risks. The chart will be difficult to read and impossible to
understand. It's possible to build such a chart, but it requires you to
build multiple 2D stacked columns with 3D effects, make them selectively
transparent, and align them in layers. It's a pain to build and to maintain,
and it's a pain when someone gives you one to interpret.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ditch" wrote in message
...
Hi Team,
I know how to do 2D stacked columns and separate 3D Column carts but I
want
to do a 3D Stacked column chart ie. 4 variables. I've explored links on
similar discussions but have seen no example.
I recognise the detrimental presentation risks on a 2D printout.
Could you please advise?
Thank you,
Ditch