![]() So if you enter "three" into this box, the first, fourth, seventh and tenth - continuing until you run out of labels - display.Ĭlick on the text box next to "Interval between tick marks." Enter the same number as your interval unit if you only want Excel to show a tick on the axis when it displays a label. The first axis label displays, then Excel skips labels until the number of your interval, and continues on in this pattern. ![]() Type in the interval that you want to use for the X-axis labels. The Format Axis window appears.Ĭlick on the radio button next to "Specify interval unit," then place your cursor into the small text box next to the button. ![]() Click the "Format Selection" button next to the drop-down arrow to continue. Click on the "Layout" tab at the top of the Excel window, then click the drop-down arrow on the left side of the ribbon and choose "Horizontal (Category) Axis" from the list of options.
0 Comments
Leave a Reply. |