Thread: Many low values, one high value- how do I avoid skewed chart?

I am trying to show a range of values (y-axis) in which on value is much
larger than the rest. I would like to know if anyone can suggest a way to
alter the y-axis so that my low values are not grossly skewed by the one high
value.

Thanks

1. Use a logarithmic scale
2. Make a broken axis:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"bpmedtech" <bpmedtech@discussions.microsoft.com> wrote in message
news:5BDF9C62-4B10-46F3-9A69-247B52A31C5C@microsoft.com...
>I am trying to show a range of values (y-axis) in which on value is much
> larger than the rest. I would like to know if anyone can suggest a way to
> alter the y-axis so that my low values are not grossly skewed by the one
> high
> value.
>
> Thanks