possiblity to set data label in bar chart to "no wrap"??

[Rhapsody]

hey,

is there a possibility to display the data label in one line (-> NO
WRAP)
the label position is "inside base" and the label should just NOT wrap
(but it automatically does )

can someone point me in the right direction?

thanks,
Rhapsy

 

[Andy Pope]

Hi,

The warp is automatically decided by xl. Font size is the only control
you have but even reducing the size may not stop wrapping.

You can add textboxes to the chart and link the content to a cell but
the position of the box will not update with changes in underlying data.

To add textbox select chart and in formula bar enter cell reference
including sheet name. So for textbox linked to A1 in sheet1 type

=Sheet1!A1

Cheers
Andy