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

[SanD]

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.

 

[Jon Peltier]

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