Matchless Hide The Primary Vertical Axis In Excel
In the popup menu.
Hide the primary vertical axis in excel. For a version in a page by itself ie not in a scrollable. To hide all axes clear the Axes check box. As a result we changed the y axis values.
For example suppose we want to plot the two series A and B in Figure 1 with the elements in column B as the x-axis values. To change the axis options of the secondary vertical axis. Click on the top horizontal axis and delete it.
By default Excel automatically determines the values on the vertical axis. One of the more common issues is how to make Excel charts primary and secondary axis the same scale. To access expert tech support contac.
If you want to move the Y axis to the right check At maximum category in Vertical axis crosses section. A secondary vertical axis is displayed in the chart. On the Design tab click the down arrow next to Add chart elements and then hover over Axes in the fly-out menu.
Click the type of axis that you want to display or hide. Message 1 of 8 11828 Views 0 Reply. While youre there set the Minimum to 0 the Maximum to 5 and the Major unit to 1.
Hide the left hand vertical axis. It is almost as if you need another line red thick line below to show. This displays the Chart Tools adding the Design and Format tabs.