In the Horizontal (Category) Axis Labels box, click Edit. Right-click the category labels you want to change, and click Select Data. To keep the text in the source data on the worksheet the way it is, and just create custom labels, you can enter new label text that's independent of the worksheet data: Type the text you want in each cell, and press Enter.Īs you change the text in the cells, the labels in the chart are updated.
Your chart uses text from its source data for these axis labels.ĭon't confuse the horizontal axis labels-Qtr 1, Qtr 2, Qtr 3, and Qtr 4, as shown below, with the legend labels below them-East Asia Sales 2009 and East Asia Sales 2010.Ĭlick each cell in the worksheet that contains the label text you want to change. Your changes should be immediately reflected in the axis labels.In a chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") axis, and next to the depth axis (in a 3-D chart). The Text Box options in the Format Axis task pane. Expand the options under the Text Box link.(It is the right-most tool in the task pane. Excel changes the tools that appear just below the link. Click the Text Options link in the task pane.Excel displays the Format Axis task pane at the right side of the screen. Right-click the axis labels whose angle you want to adjust.(They are largely different because Microsoft did away with the Format Axis dialog box, choosing instead to use a task pane.) If you are using Excel 2013 or a later version, the steps are just a bit different. You can set a positive or negative rotation, as desired. Using the Custom Angle control, adjust the angle at which you want the axis labels to appear.Excel displays the Format Axis dialog box. (You can only adjust the angle of all of the labels along an axis, not individual labels.) Excel displays a Context menu. If you are using Excel 2007 or Excel 2010, follow these steps: How you go about adjusting the angle depends on the version of Excel you are using. He would like his axis labels to be at an approximate 45-degree angle. Michael wonders if there is a way to format axis labels on his charts so that they are at an angle when compared to the actual axis line.
0 kommentar(er)
