You can use a logarithmic scale, or you could try this technique, which
works for X and Y value axes:

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

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


"SanD" wrote in message
...
My x axis range is from 0 to 2000000 and my Y values are at 0, 1000, 5000,
10000, 50000, 10000, 200000, 600000 and 2000000. When I plot my values the
first 4 data almost over lap with each other and there is a huge gap
between
the last two data points.
So my question is :
1. How can I add a brak in the x-axes (to reduce the gap between last two
data points)?

2. How can I expand the x axis (to show the first 4 data points clearly)?

I am 99.9% sure that the last option is not possible isn excel. However,
if
it is and someone know that would be of great help.