Changing Y axis to omit part of the scale

  • Thread starter Thread starter afro
  • Start date Start date
A

afro

Is it possible to omit the middle of the Y axis scale when you have
wide range of numbers?

I am already using two Y axes to plot two different data types (
number and a percentage) but there is a massive extreme in my numbe
data, causing the data at the lower end of the scale to look like i
has not been plotted on the chart.

What I would like to do is have my scale showing 0 to 10,000 then hav
a blip to indicate some missing numbers, and then restart the scal
again at 400,000 to accommodate the other data points. Any suggestions
 
Back
Top