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!
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.
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.
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.
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.
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.
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.
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.
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.
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. [2] 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.
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.
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.
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.
If you’re using Excel on a Mac, you’ll need to click the View menu and switch to Print Layout first.
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.
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.
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.
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.
