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

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?

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

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/ChartsH...sterStack.html

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


"andybx" wrote in message
...
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?

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

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

"Jon Peltier" wrote:

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/ChartsH...sterStack.html

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


"andybx" wrote in message
...
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?