In the chart, click the title that you want to move to another location.
To move the title, position the pointer on the border of the title box so that it changes to a four-headed arrow , and then drag the title box to the location that you want.
Use predefined settings to reposition a title
On a chart, click the chart title or axis title that you want to reposition.
This displays the Chart Tools, adding the Design and Format tabs.
On the Format tab, in the Current Selection group, click Format Selection.
In the Format Chart Title pane, click the Layout and Properties tab .
Expand Alignment, and then do one of the following:
To align text, in the Vertical alignment box, click the option that you want.
Note:Changes to vertical alignment will not change the position of the title on the page and will only have an effect if your title contains more than one line.
To change the direction of the text, in the Text direction box, click the option that you want.
To rotate text, in the Custom angle box, enter the degree of angle that you want.
Tip:To quickly align or rotate selected titles on a chart, you can also click the text alignment and orientation buttons in the Paragraph group on the Home tab. However, changes to text alignment will not change the position of the title on the page and will only have an effect if your title contains more than one line.
See how to reposition or move a title in a chart in Office 2016 for Mac.
Drag a title to the location that you want
In the chart, click the title that you want to move to another location.
To move the title, position the pointer on the border of the title box so that it changes to a four-headed arrow , and then drag the title box to the location that you want.
Use predefined settings to reposition a title
On a chart, click the chart title or axis title that you want to reposition.
This displays the Chart Design and Format tabs on the ribbon.
On the Format tab, click Format Pane.
The Format Chart Title dialog box displays.
In the Format Chart Title dialog box, under Title options, click the Size & Properties icon.
Under Alignment, do one of the following:
To align text, in the Vertical alignment box, click the option that you want.
Note:Changes to vertical alignment will not change the position of the title on the page and will only have an effect if your title contains more than one line.
To change the direction of the text, in the Text direction box, click the option that you want.
To rotate text, in the Custom angle box, enter the degree of angle that you want.
Click any data label once to select all of them, or double-click a specific data label you want to move. Right-click the selection >Chart Elements > Data Labels arrow, and select the placement option you want.
Click any data label once to select all of them, or double-click a specific data label you want to move. Right-click the selection >Chart Elements > Data Labels arrow, and select the placement option you want.
Click anywhere within your Excel graph to activate the Chart Tools tabs on the ribbon. On the Layout tab, click Chart Title > Above Chart or Centered Overlay.
In the chart, click the title that you want to move to another location.
To move the title, position the pointer on the border of the title box so that it changes to a four-headed arrow. , and then drag the title box to the location that you want.
Tip You can also change the horizontal alignment of axis labels, by clicking the axis, and then click Align Left , Center , or Align Right on the Home toolbar.
Select the cells for your title, right-click and choose 'Format Cells', then go to the Alignment tab.Under the 'Horizontal' drop-down menu, select 'Center Across Selection'.
Click the chart that you want to format. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Chart Styles group, click the chart style that you want to use.
To move a data label, drag it to the location you want. Note: If the text inside the data labels is too hard to read, resize the data labels by clicking them, and then dragging them to the size you want.
Drag the rows or columns to another location. Hold down OPTION and drag the rows or columns to another location. Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes space for the new row or column.
Introduction: My name is Horacio Brakus JD, I am a lively, splendid, jolly, vivacious, vast, cheerful, agreeable person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.