Download Article
Download Article
Are you having trouble changing the scale of the horizontal (X) axis in Excel? You're not alone! If you're not seeing options for changing the range or intervals on the x axis, or you just can't customize the scale how you want, you might need to switch to a chart type that supports custom scaling on the X axis. This wikiHow article will teach you how change the scale of the X axis for dates, text, and numerical values in Microsoft Excel.
Steps
-
Click anywhere in the chart. For most charts, the X axis is used for categories/text labels (including dates). [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source Start by clicking the center of your chart to display the Chart Design and Format menus at the top of Excel.
- If you're using Excel on a Mac, you'll need to click the View menu and switch to Print Layout first.
- If your X axis contains numbers that aren't dates (or you're using an X Y scatter or bar chart), the steps are a little different. You'll also have more scaling options!
-
Click the Format menu. It's at the top of Excel.Advertisement
-
Select Horizontal (Category) Axis from the drop-down menu. You'll see this menu at the top-left corner of Excel. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click Format Selection or Format Pane . You'll see one of these two options below the drop-down menu at the top-left corner.
-
Choose whether your axis is text or a date. Select Text axis if the values on your X axis are anything other than dates. If you have dates on this axis, choose Date axis . [3] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Set the date range in the "Bounds" fields (dates only). Enter the date where the X axis should begin into the "Minimum" field, and the final date into the "Maximum" field.
-
Specify the interval (dates only). In the "Units" section, you can control the interval by typing a number from the "Major" menu and choosing a duration, such as Days , Months , or Years . You'll see larger tick marks at the "Major" interval and smaller ticks at the "Minor" interval. [4] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- For example, if you want to show a larger tick mark every 30 days and a smaller one every 5 days, you'd type a "30" into the "Major" field, a "5" into the "Minor" field, and chose Days for each.
-
Set where the vertical axis (Y) crosses the horizontal axis.
- If you're working with dates, you can set the Y axis to cross between dates, at a particular date, or at the maximum (last) date.
- If you're working with text categories, you can set the Y axis to cross at a particular category number, at the maximum (last) category, or just leave "Automatic" selected and adjust as necessary.
-
Choose whether to show dates or text labels in reverse order. If you want to switch the order of the values on the X axis, check the box next to "Dates/Categories in reverse order" below the "Axis position" section.
-
Change your tick mark settings. Expand the "Tick Marks" section and customize:
- Dates: You can adjust the position of both the major and minor tick marks, or opt to leave either type out.
- Text: Enter a value into "Interval between marks" to customize the intervals between tick marks, then use the "Major" and "Minor" menus to adjust the positioning of the larger and smaller tick marks.
-
Customize the label settings. Expand the "Labels" menu to find options for the labels on the X axis.
- Dates: You can customize the placement of the dates using the "Label Position" menu.
- Text: You can specify the interval between labels by choosing Specify interval unit and entering a number. You can also customize the distance between the label and the axis, as well as the label's position.
-
Format the numbers. The chart automatically inherits the number format you used in your data. If it doesn't look right, use the options in the "Number" section at the bottom to choose a different number format.
- You can also use the icons at the top of the "Format axis" panel to customize other details of the X axis, such as the alignment and fill. [5] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Advertisement
-
Make sure you're using a chart type that supports horizontal (X) scaling. If you want to adjust the scale of a range of numbers along the X axis, you'll need a chart meant for showing and comparing numeric values. [6] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- X Y scatter and bar charts are the two chart types that let you scale any numbers on the X axis. Other chart types reserve the X axis for categories rather than values. [7] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- X Y scatter charts are usually going to be what you need, especially if you have many numerical data points on the X axis and want to scale them nicely.
- To change your chart type, right-click the middle of the current chart and choose Change Chart Type
. Then, select X Y (Scatter)
or Bar
in the left panel and choose an option.
- Both chart types have several styles you can choose from—just use the icons at the top of the window to see all of the options.
-
Click anywhere in the chart. This displays the Chart Design and Format menus at the top of Excel.
- If you're using Excel on a Mac, you'll need to click the View menu and switch to Print Layout first.
-
Click the Format menu. It's at the top of Excel. [8] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click Format Selection or Format Pane . You'll see one of these two options below the drop-down menu at the top-left corner. [9] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- Horizontal (Value) Axis only appears on XY scatter and bar charts. If you're using another chart type, you'll see Horizontal (Category) Axis instead. You can't scale category axis like you can a value axis.
-
Change the range in the "Bounds" fields. Enter the number where the X axis should begin into the "Minimum" field, and the final number in the scale in the "Maximum" field. [10] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- If you want to reverse the order, just scroll down and check the box next to "Values in reverse order."
- If you check the box next to "Logarithmic scale," each value on the X axis will be multiplied by the value you enter into the "Base" field.
-
Specify the tick mark interval. You'll set the intervals between tick marks by entering values into the "Major" and "Minor" fields.
- For example, if you want to show a larger tick mark every 100 sales and a smaller one every 50 sales, you'd type a "100" into the "Major" field, and a "50" into the "Minor" field.
- To change the orientation of the tick marks, use the options in the "Tick Marks" section a little bit below.
-
Format the numbers. The chart should automatically inherit the number format you used in your data. If it doesn't look right, use the options in the "Number" section at the bottom to choose a different number format. [11] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- You can also use the icons at the top of the "Format axis" panel to customize other details of the X axis, such as the alignment and fill. [12] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
References
- ↑ https://support.microsoft.com/en-us/topic/change-the-scale-of-the-horizontal-category-axis-in-a-chart-637897f6-0d51-4ec5-bef9-25d2c83a8450#OfficeVersion=macOS
- ↑ https://support.microsoft.com/en-us/office/change-axis-labels-in-a-chart-1c32436b-fb12-450b-aefa-cc7e4584456a
- ↑ https://support.microsoft.com/en-us/office/change-axis-labels-in-a-chart-1c32436b-fb12-450b-aefa-cc7e4584456a
- ↑ https://support.microsoft.com/en-us/office/change-axis-labels-in-a-chart-1c32436b-fb12-450b-aefa-cc7e4584456a
- ↑ https://support.microsoft.com/en-us/office/format-elements-of-a-chart-b6c787d5-f90a-41d2-a901-9d3ed9f0dbf0
- ↑ https://support.microsoft.com/en-us/office/change-axis-labels-in-a-chart-1c32436b-fb12-450b-aefa-cc7e4584456a
- ↑ https://support.microsoft.com/en-us/office/available-chart-types-in-office-a6187218-807e-4103-9e0a-27cdb19afb90
- ↑ https://support.microsoft.com/en-us/office/change-the-scale-of-the-vertical-value-axis-in-a-chart-05973661-e56a-4486-a9f3-f9ce41df0021
- ↑ https://support.microsoft.com/en-us/office/change-the-scale-of-the-vertical-value-axis-in-a-chart-05973661-e56a-4486-a9f3-f9ce41df0021
- ↑ https://support.microsoft.com/en-us/office/change-the-scale-of-the-vertical-value-axis-in-a-chart-05973661-e56a-4486-a9f3-f9ce41df0021
- ↑ https://support.microsoft.com/en-us/office/change-axis-labels-in-a-chart-1c32436b-fb12-450b-aefa-cc7e4584456a
- ↑ https://support.microsoft.com/en-us/office/format-elements-of-a-chart-b6c787d5-f90a-41d2-a901-9d3ed9f0dbf0
About This Article
Article Summary
X
1. If you need to scale numbers on the X axis, you'll want to switch your chart to an X Y scatter chart.
2. Then, click the chart and click the Format
tab.
3. Click Format Selection
for Format Pane
.
4. Click Axis Options
.
5. Customize your range and tick mark intervals.
Did this summary help you?
Thanks to all authors for creating a page that has been read 37,790 times.
Advertisement
