Depending on your chart, the “Y-axis” may overlap the previous category. Go to “Axis Options -> Vertical axis crosses,” then choose “Automatic,” “At category number,” or “At maximum category.” If choosing “At category number,” type the value you want to become the crosspoint. To change the crosspoint of the Y-axis over the X-Axis, select the “X-Axis” instead.Click the dropdowns next to “Major Type” and “Minor type,” then make your selection. To adjust the placement of tick marks, go to the “Tick Marks” section.To revert the changes, click on “Reset.” The “Minor” settings may not appear in the chart at first until you change the tick options later. This step also adjusts the tick spacing based on your “Bounds” settings.
To change the interval of units (10, 1000, etc.), go to the “Axis Options -> Units” section, then type a new number in the “Major” and “Minor” options.Note: Red marks in the images below are actions, and green marks are for reference. To change the appearance of the Excel Y-Axis, ensure you have selected it in your chart before following any of the steps below (unless instructed otherwise), or else, you’ll get the wrong options and settings. No matter what values and text you want to show on the vertical axis (Y-axis), here’s how to do it. You might even want to adjust the increments in the chart. For instance, you may want to shrink the range down a little to focus on a particular range or reverse the order of the axis. Sometimes, you may want a different set of values than what Excel prepopulates. Changing the Y-Axis Scale in ExcelĪssuming that you want to change the vertical value axis (Y-axis) in your Excel chart/graph, you can customize its values to cover an extensive range or transform it into a logarithmic scale that fits your needs. In this article, we’ll guide you through how to change the y-axis (vertical/value axis) in Excel and tell you more about its functionality. With new updates, its functionality and processing power are expanding, making it capable of handling massive amounts of data. It’s a powerful tool that can transform how you see and understand data in any work environment. Working knowledge of Excel is one of the must-have skills for every professional today.
0 kommentar(er)
