VBA: data label text is being cut off

[vlad7984]

Hi. I am editing the data labels to include text based on a data series. The text includes small paragraph descriptions which are being cut off arbitrarily. The rest of the text does not reappear upon resizing the text box.

This is my code:
ActiveChart.FullSeriesCollection(2).Select
ActiveChart.SetElement (msoElementDataLabelCallout)

ActiveChart.FullSeriesCollection(2).DataLabels.Select
Application.CutCopyMode = False
ActiveChart.SeriesCollection(2).DataLabels.Format.TextFrame2.TextRange. _
InsertChartField msoChartFieldRange, "=Data!$F$2:$F$173", 0
Selection.ShowRange = True

Anyone know how to get the full text to show or why excel is cutting it off?

Edit: Ok it seems like excel has a 255 character limit for data labels. Is there anyway to skirt this?

 

[Jon Peltier]

Yeah, that 255 character limit looks pretty firm.

For shorter labels I have played with settings like WordWrap and AutoSize to make the whole label appear on a single line, so it's not truncated.

But once you get to labels which are tool long, you're out of luck.

 

[vlad7984]

Gotcha, thanks.

 

[Jack in the UK]

First I would check the printer as its not stated here, and that the drivers are correct

Labels are beasts at best.

Next check that the driver is set to the correct label stock, with the gap, continue and mark set as required
Check the labels area are set to what you want in the driver (there are normally two scopes/areas for this)

Check the user printer settings is NOT ticked

Now re print and see what happens with the output

Also you must calibrate the printer, with know the make and model number I can not advise on this bit, but its a must and should be re calibrated every time the case is opened or roll replaced

Regards
jiuk

 

[Jon Peltier]

We're talking about data labels on chart data points, not adhesive printer labels.

 

[vlad7984]

I appreciate the well thought out answer but as Jon stated, we are talking about data labels that are added to charts/graphs.