![]() Otherwise, leave this at "one" and every tick mark displays on the axis, whether it has a label or not.Ĭlick "Close" to close the Format Axis window and apply the changes to your chart. 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. If you have long axis labels in a column chart, Excel will rotate them to fit the full labels in if the chart is not wide enough. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |