Click on the “Chart Tools” and then “Design” and “Format” tabs.Bring your cursor to the chart and click anywhere.Additionally, you can also decide on the amount of space between the levels of labels.

In a situation where you have multiple categories in your chart, there’s an option that helps you align labels on all levels. Change the Alignment and Orientation of Labels With fewer marks and using bigger and smaller labels, your table will have a clearer structure, and your team will be able to use it without any issues. Adjusting the way they’re on display will remove any clutter or unnecessary information. Whenever you create a chart, you’ll notice that all marks and labels are there by default. Click the dropdown next to “Label Position,” then make your selection. To change the axis label’s position, go to the “Labels” section.Click the dropdowns next to “Major Type” and “Minor type,” then make your selection. To adjust the placement of tick marks, go to the “Tick Marks” section.This action also reverses the horizontal axis to reflect accuracy in your chart or graph. To reverse the order of the vertical values, go to the “Axis Options -> Display units” section, then add a checkmark in the “Values in reverse order” box.To switch the value axis to a logarithmic scale, go to the “Axis Options -> Display units” section, then add a checkmark in the “Logarithmic scale” box.Add a checkmark in the “Show display units label on chart” box, then type your “unit label” such as “Numbers based in millions.” To label the displayed units, go to the “Axis Options -> Display units” section.Click the dropdown next to “Display Units,” then make your selection such as “millions” or “hundreds.” To change the displayed units, such as changing 1,000,000 to 1 where units represent millions, go to the “Axis Options -> Display units” section.To change the crosspoint of the X and Y axis, go to the “Axis Options -> Vertical axis crosses” option, then choose “Automatic,” “Axis value,” or “Maximum axis value.” If choosing “Axis value,” type the value you want to become the crosspoint.If you need to revert the change, click on “Reset.” To change the interval/spacing of tick marks or grid lines, go to the “Axis Options -> Units” section, then type a new number in the “Major unit” or “Minor unit” option depending on your needs.To change the beginning and ending or minimum and maximum values, go to the “Axis Options -> Bounds” section, then type a new number in the “Minimum” and “Maximum” boxes.Click on the “Format” tab, then choose “Format Selection.”.It will show a border to represent that it is highlighted/selected. In your chart, click the “Y axis” that you want to change.3) Drag the orientation indicator or type the number of degrees you want in the Degrees field. The Format cells dialog box opens to the Alignment tab. 2) Click the dialog box launcher in the Alignment group. You can use the Alignment tab in the Format Cells dialog box to manually set the text direction. The Rotate Text Up option sets the text to 90 degrees, the Rotate Text Down option sets the text to -90 degrees, and the default orientation - horizontal - is 0 degrees. Excel measures the direction of text in degrees. Excel changes the text direction. The following graphics illustrate the five direction options listed on the menu. Click the down-arrow next to the Orientation button in the Alignment group.You can change the text direction by clicking the Orientation button and then choosing a direction option from the Orientation menu. In Excel, when entering text in English, by default, text reads from left to right and is horizontal. Author: Sharlie Last modified: November 19 2015

How to change text direction in excel