Adjust Chart Text For Free

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.

Use text formatting to format text in chart elementsClick the chart element that contains the text that you want to format.Right-click the text or select the text that you want to format, and then do one of the following: Click the formatting options that you want on the Mini toolbar.

To format data labels in Excel, choose the set of data labels to format. To do this, click the Format tab within the Chart Tools contextual tab in the Ribbon. Then select the data labels to format from the Chart Elements drop-down in the Current Selection button group.

To change the format of text in category axis labels: Right-click the category axis labels you want to format, and click Font. On the Font tab, choose the formatting options you want.

Edit the contents of a title or data label that is linked to data on the worksheetIn 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.

To format data labels, select your chart, and then in the Chart Design tab, click Add Chart Element > Data Labels > More Data Label Options. Click Label Options and under Label Contains, pick the options you want. To make data labels easier to read, you can move them inside the data points or even outside of the chart.

Click the data label and drag it to the size you want. Tip: You can set other size (Excel and PowerPoint) and alignment options in Size & Properties (Layout & Properties in Outlook or Word). Double-click the data label and then click Size & Properties.