can you put breaks in y axis?

rustycar

New Member
Joined
Feb 15, 2002
Messages
10
can you place breaks in the y-axis? If not directly, any way to trick excel into doing it?

thanks
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Hi Rustycar,

I don't believe there is a way to break an axis--I assume you mean a discontinuity--with Excel charts. However, you can make it appear to be a single chart with broken axis by actually overlaying two charts that have exactly the same x-axis scale, then setting the y-axis scales for the two charts separately to provide the discontinuity. Remove the x-axis from the chart with the higher y-axis values and move it up above the other charts, and bring it forward so it is on top of the other. By removing the background fill from the topmost chart the bottom chart can show through. You will also need to remove the border from the topmost chart.

I hope this is enough to get you going.
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top