Vertical axis numbering - cut out the middle numbers

Hozz

Board Regular
Joined
Feb 10, 2005
Messages
140
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?
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,261
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

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,771
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,799
Messages
5,446,547
Members
405,406
Latest member
tuxy

This Week's Hot Topics

Top