Thanks Jon for the detailed explanation on how to plot the outlier on the
column chart. I understood the concept behind it, but my data is not as
simple as yours.
My values for the 6 products for category 1(0.9, 1.6,4.4,2.8,0.6, and 9.8)
for category 2(2.4,5.8,19.2,12.7,3,111.3), and category
3(27.4,82.6,430.9,13.6,3.2,0.1).
I decided to have my brk pt at 28 and max pt at 128 so the difference is
100, but I ended up with negatives points, and the 'Y' axis still overwhelmed
with the values range variation.
The data in your example is organized. You have 2 values out of range, but
not much difference between those two points. While I have most of my values
under 28, then I have 82, 111, and 430 which makes it a little diffecult to
plot. Or may be i'm not following the technique correctly?

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


"Jon Peltier" wrote:

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.