DataLabel Manipulation

P

Patrick

This seems like it would be an extremely simple problem to solve but I
can't find a property or method etc to use on a DataLabel object to
change the width or prevent word wrapping when used on pie charts with
a lot of DataLabels.

ActiveChart.SeriesCollection(1).Points(1).DataLabel

How do I increase the width/height of this manually or change the
default word wrap behaviour?

Thanks for any help in advance,

Patrick
 
J

Jim Cone

This post has some information...
http://tinyurl.com/kjp52
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Patrick" <[email protected]>
wrote in message
This seems like it would be an extremely simple problem to solve but I
can't find a property or method etc to use on a DataLabel object to
change the width or prevent word wrapping when used on pie charts with
a lot of DataLabels.

ActiveChart.SeriesCollection(1).Points(1).DataLabel

How do I increase the width/height of this manually or change the
default word wrap behaviour?

Thanks for any help in advance,

Patrick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart DataLabel Placement Error 2
Format only part of a DataLabel in Excel 2007/PowerPoint 2007 char 6
Method 'Left' of object 'DataLabel' failed 2
Formatting Excel charts created with VBA 0
Data Labels Macro 4
Adjusting height of text cells 3
Change Gradient Fill Colors of Bar Chart data points 2
Size a Cell to a Picture 0

Top