VBA: data label text is being cut off

vlad7984

New Member
Joined
May 24, 2019
Messages
14
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?
 
Last edited:

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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.
 
Upvote 0
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
 
Upvote 0
We're talking about data labels on chart data points, not adhesive printer labels.
 
Upvote 0
I appreciate the well thought out answer but as Jon stated, we are talking about data labels that are added to charts/graphs.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top