Having a chart creation issue

[jeff]

TAke a look at

http://www.tushar-mehta.com/index.html?http://www.tushar-
mehta.com/excel/newsgroups/dynamic_charts/index.html

select broken y-axis in left menu

jeff

-----Original Message-----
I am trying to create a line graph with a single x - and

y - axis, but I need to somehow put a break in my scale
half-way up the y-axis. The y-axis is in dollars, and I
have a series of lines, some with high dollar amounts and
some with low. I need to accentuate the low and high
trends by putting a break in the y-axis scale so I can go
from 0 to 100,000, then start again from 500,000 to
800,000.

How can I develop this two-tiered scale? (Note: I

don't want to use a 2-axis chart!)