Vertical axis numbering - cut out the middle numbers

[Hozz]

Hi all,

I want to create a line graph with 2 series' data in it.
The problem is the 2 series are very different in number range. Series 1 ranged from 60-180 and series 2 ranges from 0-10.

because the graph needs to be reasonably small, series 2 can barely be seen.
Is there a way of cutting/hiding 11-59 from the graph and then expanding 0-10 to take up space made by removing those numbers?

 

[AlphaFrog]

You could use a logarithmic scale on the Y axis (very easy).

You could create a secondary Y axis (very easy)
Add or remove a secondary axis in a chart

You could make a panel Chart (easy)
Panel Chart

Or you could create a broken Y axis (hard)
(Do a web search for something like Excel Broken Y axis for a few tutorials and examples.)

 

[pgc01]

Hi

For the broken Y axis see Andy Pope's solution:

AJP Excel Information

but first check Jon Peltier's "Panel Chart" link in AlphaFrog's post to see that a panel chart may be a better solution.