How can I add a break in the X or Y axes?

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.

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" <SanD@discussions.microsoft.com> wrote in message
news:89A7F1DE-0E68-4484-9B36-E91B90D90BDA@microsoft.com...
> 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.