Arrange Chart Text For Free

Edit or rearrange a seriesRight-click your chart, and then choose Select Data.In the Legend Entries (Series) box, click the series you want to change.Click Edit, make your changes, and click OK.To rearrange a series, select it, and then click Move Up or Move Down .

In the worksheet, click the cell that contains the title or data label text that you want to change. Edit the existing contents, or type the new text or value, and then press ENTER. The changes you made automatically appear on the chart.

Change the chart text fontRight click the chart title and click Font.Click the Font tab, and enter the new size in the Size box.

Add a text box to a chartClick the chart to which you want to add a text box.In Office 2013 and newer versions: On the Format tab, in the Insert Shapes group, click the Text Box icon .In the chart, click where you want to start a corner of the text box, and then drag until the text box is the size that you want.More items...

Moving Objects with a ChartClick on the text box to select it.Hold down the Shift key as you click on the line you added.Continue holding down the Shift key as you click the chart.Release the Shift key.Display the Format tab of the ribbon.In the Arrange group, click the Group tool and then choose the Group option.Feb 1, 2021

Under Chart Tools, on the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series that you want to change the order of. Click the Move Up or Move Down arrows to move the data series to the position that you want.

Moving Objects with a ChartClick on the text box to select it.Hold down the Shift key as you click on the line you added.Continue holding down the Shift key as you click the chart.Release the Shift key.Display the Format tab of the ribbon.In the Arrange group, click the Group tool and then choose the Group option.Feb 1, 2021