Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rhapsody - 27 Sep 2006 11:35 GMT
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 - 27 Sep 2006 12:29 GMT
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

> hey,
>
[quoted text clipped - 7 lines]
> thanks,
> Rhapsy

Signature

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.