How To Add A Second Y Axis In Excel

_{Updated April 24, 2022, past Steve Larner, to add together details on irresolute the Y-axis.}

How to Change the Y Axis in Excel

Working knowledge of Excel is one of the must-have skills for every professional today. It'south a powerful tool that can transform how yous see and understand data in any work surround. What's more, with new updates, its functionality and processing power are expanding, making it capable of treatment massive amounts of data.

In this commodity, we'll guide y'all through how to change the y-centrality (vertical/value axis) in Excel and tell you more most its functionality.

Changing the Y Axis Scale in Excel

Assuming that you want to change the vertical value axis (Y-axis) in your Excel nautical chart/graph, you lot can customize its values to embrace an extensive range or transform it into a logarithmic scale. Sometimes, you lot may want a different set of values than what Excel prepopulates. For case, y'all may desire to compress the range down a little to focus on a item range or reverse the order of the axis. No thing what values and text y'all want to prove on the vertical axis (Y-axis), here's how to do it.

In your chart, click the "Y centrality" that you desire to alter. Information technology will testify a border to represent that it is highlighted/selected.
Click on the "Format" tab, then cull "Format Pick."
The "Format Axis" dialog box appears.
To alter the beginning and ending or minimum and maximum values, get to the "Centrality Options -> Premises" section, then type a new number in the "Minimum" and "Maximum" boxes. If you need to revert the modify, click on "Reset."
To change the interval/spacing of tick marks or filigree lines, go to the "Axis Options -> Units" section, then blazon a new number in the "Major unit" or "Modest unit" option depending on your needs. If you need to revert the change, click on "Reset."
To change the crosspoint of the 10 and Y axis, get to the "Axis Options -> Vertical centrality crosses" selection, then cull "Automatic," "Centrality value," or "Maximum axis value." If choosing "Axis value," blazon the value yous want to get the crosspoint.
To alter the displayed units, such equally changing i,000,000 to 1 where units stand for millions, go to the "Axis Options -> Display units" section. Click the dropdown next to "Display Units," and so make your selection such equally "millions" or "hundreds."
To label the displayed units, get to the "Axis Options -> Display units" department. Add a checkmark in the "Testify display units label on chart" box, then blazon your "unit of measurement label" such as "Numbers based in millions."
To switch the value axis to a logarithmic scale, become to the "Centrality Options -> Display units" section, then add together a checkmark in the "Logarithmic scale" box.
To reverse the order of the vertical values, become to the "Axis Options -> Display units" section, then add together a checkmark in the "Values in reverse club" box. This action also reverses the horizontal axis to reverberate accurateness in your chart or graph.
To adjust the placement of tick marks, go to the "Tick Marks" department. Click the dropdowns side by side to "Major Type" and "Modest type," then make your selection.
To change the centrality label'south position, go to the "Labels" section. Click the dropdown adjacent to "Characterization Position," then make your selection.

Changing the Display of Axes in Excel

Every new nautical chart in Excel comes with two default axes: value axis or vertical axis (Y) and category axis or horizontal axis (X). If yous're making a 3D chart, in that case, there's going to be a third one called the depth centrality (Z). Editing or changing any of the axes results in modifying how information is presented, what you lot can read from the chart, and where the emphasis lies.

Hiding and Unhiding Axes

When you lot're working with unlike types of projects, information technology might come in handy to hibernate some of the axes to make your graphs more legible or to stress important numbers. Here's how to exercise this:

Bring the cursor to the chart where you lot desire to alter the axes' appearance.
Get to "Design," then get to "Add Chart Element" and "Axes."
You'll have two options: "Primary Horizontal" will hide/unhide the horizontal centrality, and if y'all choose "Primary Vertical," it will hide/unhide the vertical i.
Click on the option you lot need.

Adapt Centrality Marks

Whenever you create a nautical chart, you lot'll observe that all marks and labels are there past default. Adjusting the way they're on display will remove any clutter or unnecessary information. With fewer marks and using bigger and smaller labels, your table volition accept a clearer structure, and your team volition exist able to use information technology without any problems.

Change the Alignment and Orientation of Labels

In a situation where you have multiple categories in your nautical chart, at that place'south an pick that helps you marshal labels on all levels. Additionally, you can besides decide on the amount of space betwixt the levels of labels. Here's how to do this:

Bring your cursor to the chart and click anywhere.
Click on the "Chart Tools" and so "Design" and "Format" tabs.
When y'all open the "Format" tab, click on the "Format Selection" and click on the axis you want to alter.
If you lot go to "Format," "Format Axis," and "Text Options," you lot can cull for the text to be aligned vertically, horizontally, or to have a customized angle.

Change Appearance of Text and Numbers

Microsoft Excel allows y'all to format text and numbers in the category centrality. Here's how to format your text:

Click on the axis that you lot want to customize.
Click on "Habitation" toolbar and click on the formatting options you lot'd like to employ.

When you're ready to format numbers, follow these steps:

Click on the axis that y'all want to customize.
Open the "Format" tab and select "Format Selection."
Become to the "Axis Options", click on "Number" and select "Number" from the dropdown selection nether Category. Here, yous tin can choose among dissimilar numbering formats.

Change the Color of a Chart

For people working with charts all the fourth dimension, information technology'south pivotal to mark them conspicuously, and sometimes the all-time mode to do information technology is to use colour. If your tabular array is blackness and white and in need of some color to make it more impactful, here's how to add information technology:

Bring the cursor to the chart where you want to modify the color.
Click on "Design" tab. The "Chart Styles" pick is located on the upper right corner.
Once you lot click on it, you'll see the "Style" and "Color" options for your nautical chart.
Whorl and choose the color and nautical chart style y'all similar.

Change the Color of Rows and Columns

Just a chip of colour can make all the difference in a table. If you desire to add together color to alternate rows and columns, here's how to practise it:

You need to select all the cells or columns.
Press "Home" and "Format as Table."
Cull a style that supports different colors and shading.
Go to "Design," and from there you tin can cheque and uncheck all the rows and columns you want shaded.

Conclusion

One of the about powerful Microsoft Office tools at whatever workplace around the world is Microsoft Excel. In that location'southward no business that cannot benefit from using charts, lists, and various graphs to analyze, budget, organize or keep track of expenses. Excel proved itself pivotal for multiple industries that rely on the systematization that Excel provides.

Now that you know how to change and hide axes and format text and numbers, you'll get acquainted with excel a bit more and use it fully. Are yous currently working with Excel? Are you using it to make lists at home, or is it strictly for business organisation?

Let u.s.a. know in the comments section beneath.