Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default possiblity to set data label in bar chart to "no wrap"??

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

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default possiblity to set data label in bar chart to "no wrap"??

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

Rhapsody wrote:
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, Microsoft MVP - Excel
http://www.andypope.info
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
How change dimensions of data label text box in pie chart? Gouden Willem Charts and Charting in Excel 3 March 7th 06 12:11 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
Help making a chart that doesn't graph cells without data? Filtration Guy Excel Discussion (Misc queries) 0 March 22nd 05 09:21 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"