ExcelBanter - Resize data labels

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Resize data labels (https://www.excelbanter.com/charts-charting-excel/12403-resize-data-labels.html)

maonet23

Resize data labels

How to resize data labels to take up one line without changing font size?

I am using MS Excel 2002.

Andy Pope

Hi,

You can not specify the height and width of data labels.
Try using textboxes instead, which can be linked to cells.

Select the chart and then in the formula bar type in the sheet and cell
reference, or once in the formula bar click the required linked cell.

Cheers
Andy

maonet23 wrote:
How to resize data labels to take up one line without changing font size?

I am using MS Excel 2002.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 09:09 AM.