How To Set Axis In Excel

Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2022, 2022, 2022, and Excel in Part 365. If y'all are using an earlier version (Excel 2003 or earlier), this tip may non work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Irresolute the Centrality Scale.

Irresolute the Axis Calibration

Excel includes an impressive graphing capability that can plow the dullest data into outstanding charts, consummate with all sorts of whiz-blindside do-dads to amaze your friends and derange your enemies. While Excel tin automatically handle many of the mundane tasks associated with turning raw data into a nautical chart, you may withal desire to modify some elements of your chart.

For instance, you may want to change the scale Excel uses along an axis of your nautical chart. (The scale automatically chosen past Excel may not represent the entire universe of possibilities you want conveyed in your chart.) You can alter the scale used by Excel past following these steps in Excel 2007 or Excel 2010:

Right-click on the centrality whose scale you want to modify. Excel displays a Context menu for the axis.
Choose Format Axis from the Context carte du jour. (If at that place is no Format Axis choice, so you did non correct-click on an centrality in step 1.) Excel displays the Format Axis dialog box.
Make sure Axis Options is clicked at the left of the dialog box. (See Figure one.)

Figure 1. The Centrality Options of the Format Axis dialog box.

Adjust the scale settings (meridian of the dialog box—Minimum, Maximum, etc.) every bit desired.
Click on OK.

In Excel 2022 and later versions, the steps are different:

Right-click on the axis whose scale you want to change. Excel displays a Context menu for the centrality.
Choose Format Axis from the Context bill of fare. (If there is no Format Axis choice, then you did not right-click on an axis in stride 1.) Excel displays the Format Axis task pane at the right side of the screen.
Brand sure Axis Options area is expanded. (Click on Axis Options and so the Axis Options icon.) (See Figure 2.)

Figure 2. The Axis Options in the Format Axis job pane.

Arrange the Bounds and Units settings, equally desired. These, along with a couple of other settings in the chore pane, decide the scale used to display your chart.
Close the Format Axis chore pane.

Note that in order to adjust the Bounds and Units settings, Excel needs to recognize the information in an axis equally a range of values (eastward.thousand. dates). There will not exist the option to alter Premises and Units if the data is recognized as unimposing values by Excel (eastward.g. item names).

ExcelTips is your source for cost-effective Microsoft Excel grooming. This tip (9267) applies to Microsoft Excel 2007, 2010, 2022, 2022, 2022, and Excel in Office 365. You tin observe a version of this tip for the older carte du jour interface of Excel here: Changing the Centrality Scale.

Author Bio

With more than 50 non-fiction books and numerous mag articles to his credit, Allen Wyatt is an internationally recognized writer. He is president of Sharon Parq Assembly, a computer and publishing services company. Learn more about Allen...

More than FROM ALLEN

Adjusting Column Width Using Menus

If yous want to resize the width of your table columns, you tin do information technology using a mouse, but you tin get more precise widths ...

Observe More

Changing Toolbar Buttons with VBA

Toolbar buttons can accept a dissimilar appearance depending on their state�"whether they take been clicked or not. This ...

Discover More

Issues Saving as PDF

When sharing documents with others, it's difficult to crush the versatility and consistency of a PDF file. Discussion 2010 allows you ...

Discover More than

More ExcelTips (ribbon)

Irresolute Y-Axis Characterization Width

Excel provides quite a bit of flexibility in how your chart looks. One of the least flexible places is in adjusting the ...

Discover More than

Specifying the Size of Chart Objects

Unhappy with the default size that Excel uses for embedded nautical chart objects? You can't change the size at which they are ...

Detect More

Deleting a Chart

Charts serve a purpose, and sometimes that purpose is temporary. If you desire to get rid of a chart, here'due south how to do it.

Observe More