Note: Excel ignores manual page breaks when you use the Fit To option. Reduce or enlarge a sheet to fit the page On the Layout tab, under Print, in the Scale box, enter the percentage to reduce or enlarge the sheet.

You can change the axis units to change the scale of axis. Right click at the axis you want to change, select Format Axis from context menu. See screenshot: 2. In the Format Axis dialog, check Major unit’s Fixed option, then in the text box, type a new unit you need.

A red squiggly line under the misspelled word indicates a spelling error.

See screenshot: Tip: If you think the scale of axis is so large, you can type a smaller unit, whereas, type a larger unit. Click Close to exit dialog. Now you can see the scale of axis is changed. In Excel 2013, you can change the scale of axis in a chart with following steps: 1. Right click the axis you want to change, select Format Axis from context menu.

In the Format Axis pane in the right, click the Axis Options button, and change the number in the Major box in the Units section. See screen shot below. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful: • Merge Cell/Rows/Columns without Losing Data. • Combine and Consolidate Multiple Sheets and Workbooks. • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.

• Count by Colors, Paging Subtotals, Advanced Sort and Super Filter, • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.

The X-axis, which is the horizontal axis, on most Excel charts does not use numeric intervals like the vertical Y-axis does. The X-axis contains either strings of text or a date under each set of data points. You can choose to have this axis only display the text or date at certain intervals, but the process is a little different depending on what kind of axis you have. Showing the axis labels at certain intervals can be helpful if your axis text is large, you have limited space on the graph or the missing intervals can be easily deduced using the remaining labels.