How can I combine a 3-D column and stacked column chart

[Guest]

Imagine that your income comes from two streams. To make clearer the
year-on-year differecnes you like to display a 3D chart by year by month, but
use a stacked column to show the two income streams:
X = month
y = stacked two incomes
z = year on year
This doesn't seem to be one of the options. Any ideas?

 

[Jon Peltier]

3D charts cannot be combined with other chart types. They also tend to skew
the data and add lots of shapes that are more distracting than elucidating.

Can't you use a different chart type, in 2D? Your data isn't strictly XYZ
data. A clustered column chart shows data just as well as or better than a
3D column chart. To get a clustered stacked column chart appearance, follow
one of the examples on this page:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

- Jon

 

[Guest]

Jon
Thanks for this. I found this very elegant chart solution while looking
through the other queries, but unfortunately it's not what I've been asked to
do. The idea of the 3-D chart is that people who don't understand much (like
me) can see trends both through the year and across the years at a glance.
Plus for the two different streams (Y-axis) I could revesrse the order they
display depending on the audience.
But I appreciate you taking your time and your speedy reply
Andy