How To Change X Axis Scale In Excel

Please Notation: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If y'all are using a afterward version (Excel 2007 or afterwards), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Changing the Axis Scale.

Changing the Axis Scale

Excel includes an impressive graphing adequacy that tin can plough the dullest data into outstanding charts, complete with all sorts of whiz-bang do-dads to amaze your friends and derange your enemies. While Excel can automatically handle many of the mundane tasks associated with turning raw data into a chart, you may still want to change some elements of your nautical chart.

For instance, you may want to change the calibration Excel uses forth an centrality of your chart. (The scale automatically chosen by Excel may not represent the unabridged universe of possibilities you want conveyed in your chart.) Yous can change the scale used by Excel by following these steps:

1. Correct-click on the axis whose scale you want to alter. Excel displays a Context menu for the axis.
2. Choose Format Axis from the Context menu. (If there is no Format Centrality choice, then you lot did not correct-click on an axis in step 1.) Excel displays the Format Centrality dialog box.
3. Brand sure the Scale tab is selected. (See Figure 1.)



Figure i. The Scale tab of the Format Centrality dialog box.

4. Adjust the calibration settings, as desired.
5. Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3031) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and afterwards) hither: Changing the Axis Scale.

Author Bio

With more than fifty non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more than almost Allen...

MORE FROM ALLEN

How to Stop a Table Row from Splitting Over Ii Pages

Exercise you want your tabular array rows to be split betwixt pages? Give-and-take allows you to format the table so that rows stay together and ...

Discover More

Bankroll Up Your AutoCorrect Entries

Develop a lot of AutoCorrect entries and y'all may start to wonder how you can back them upwardly. You can hands protect all the ...

Discover More

Cropping Graphics

Need your hide some of the outside edges of a graphic? Y'all can instruct Give-and-take to crop (or hide) those outside edges past ...

Discover More

More ExcelTips (carte)

Filling a Drawing Object

Want to add some spice to the graphics in your worksheets? There are many colors and furnishings in Excel that let yous take ...

Discover More

Group and Ungrouping Objects

When y'all add multiple graphic objects in a worksheet, it can ofttimes be beneficial to group those objects together. Here's ...

Discover More than

Locking Callouts to a Graph Location

If yous add together callouts using the drawing tools in Excel, you lot may take noticed that they don't always stay where you expect ...

Notice More

Source: https://excel.tips.net/T003031_Changing_the_Axis_Scale.html

Posted by: espinozaexuld1949.blogspot.com

Share this post