Outrageous Excel Graph Break Y Axis

09-06-2013 0529 PM 2.

Excel graph break y axis. How to Simulate a Broken axis Value Axis. My problem is that my sales are really higher than my others values. Create the chart select the y xis right click format axis select the line type.

Subscribe to RSS Feed. We will right-click on the Secondary vertical axis and select Format Axis from the drop-down menu. Click OK to close dialog and you see the chart is inserted with two y axes.

When the values that are plotted in the chart cover a very large range you can also change the value axis to a logarithmic scale also known as log scale. Right click on one of your series in the chart select Format Data Series choose the Axis Tab and where it says Plot Series on choose Secondary Axis. In format axis enter minimum to 0 and in maximum enter the point after which you want to create the break in the graph.

You can change the base of the log scale until the chart. But it doesnt create a scale break chart per se. Want to learn how to design a salary structure.

Report Inappropriate Content Feb 19 2020 0322 AM. In the Select Data Source dialog box click to select the For broken Y axis in the Legend Entries Series section and click the Edit button. Ad Get More Results from Your Graphs for Less Effort.

By default Microsoft Office Excel determines the minimum and maximum scale values of the vertical value axis also known as the y axis when you create a chart. Depending on our Excel Version we will proceed as follows. That said in some very rare cases you may need to use them.