Hi,

One way would be to break the Value axis.
For work around instructions see
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Cheers
Andy

LiveUser wrote:
My chart is not very clear at this time.

I have a few items of data A, B, C, and D.

A has 250 of X.
B has 30 of X.
C has 0 of X.
D has 1 of X.

Since 250 is such a large difference from 1, D is almost non-existent. Is
there any way to increase the view size of 1?

Microsoft 2003.

Live User



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info