Changing Y axis to omit part of the scale

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dual y-axis align grid, drop line to y axis, add-ins 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Axis scale on X-Y scatter graph 2
Auto-scaling on Y axis inconsistent 4
Value Y axis - Not to start from zero 2
Horizontal Gridlines not matching secondary Y-axis 3
Automatic Y axis scaling 1
How do I change the scale on the y axis to letters? 3

Top