Excel Graphing With Widely Divergent Values

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

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!
 
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.
 
Back
Top