View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?