Resize data labels

[maonet23]

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