I would try a number of other chart types. First, the sooner you get away
from 3D types, the sooner your data is undistorted by false perspective etc.
Second, 2D charts provide numerous ways to deal with things like this.

When one item out of many is well out of range of the others, there are
three commonly suggested workarounds:
1. Plot the outlier on the secondary axis.
2. Use a logarithmic value axis scale.
3. Put a break in the value axis:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

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


"sahafi" wrote in message
...
This is a simple question: I'm comparing 6 different products across 3
categories on a 3D stacked column chart. Everything is fine to this point.
My
issue, one of the products has very large values in 2 ctegories out of 3
in
comparison to the other 5 products. My data values range from 1 to 30 but
the
6th product ranges from 1 to 500. What's the best way to approach this,
other
than not to plot the 6th product?


Thanks.
--
If u change the way u look @ things, the things u look at change.