Excel Graphing With Widely Divergent Values

I searched but couldn't find anythign about this problem. Here's the
basic premise:

I've got two dollar variables I want to graph over time. The first
variable is in the $10 range over the period. The second variable is
in the $100,000 range. How can I adjust/concatenate/whatever the scale
so that I can meaningfully display the two variables on one graph?
Right now, I end up with two straight lines separated by acres of blank
space.

Thanks!

Select the custom chart type, "Line - Column on 2 Axes".

I'd already done that, but had hoped there was a way to adjust the
scale to skip over blank space. I've seen other graphs (maybe not done
in Excel, but I don't know), that have this little squiggly design on
the Y axis denoting a bunch of values were skipped over.

Hi,

The broken axis is not a built in feature.
Here is an example work around, which includes links to other examples.
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

Jerry wrote:
> I'd already done that, but had hoped there was a way to adjust the
> scale to skip over blank space. I've seen other graphs (maybe not done
> in Excel, but I don't know), that have this little squiggly design on
> the Y axis denoting a bunch of values were skipped over.
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

That's exactly what I was looking to do. Thanks a lot, Andy!