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.