Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.that should work.Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% To change the number of characters per line, change "12" to N and "13" to N+1. Maybe with more work you could have it look for the next space character and tell it to return if there will be more than N characters on that line. The downside is that it will split words across the return, but I was desperate.
1) & Chr(10) & Right(Selection.Value, _īasically I cycle through all the category labels (I have them in K1:K10 or whatever) and insert a return in the text after every 12 characters, so it's wrapped in effect. Selection.Value = Left(Selection.Value, b * 13 _ If Len(Selection.Value) > 65 Then Selection.Value _įor b = 1 To Int(Len(Selection.Value) / 12) To three layers for me, but it would seem to me that there should be aĬontrol for text-wrapping on axis labels that I use to change this. Return in the cell containing the text for the label will accomplish wrapping To change the font size of the label for the same reason. Standardised so that the reports are visually consistent. I know that lengthening the axis would help, but the size of the graph is Wrapping to three layers (as I would expect it to) the text is not wrapped atĪll, on any of the labels, and so simply overlaps all the other labels. Every now and then, one of the labels is too long, and instead of This text is being wrapped to two layers on the label that appear on theĬhart. The text in the labels is of varying lengths and for some of the charts, The labels for the horizontal axis are linked to textĪlongside the calculations for the charts. The charts are waterfall charts, which I've constructed using a form I've a small problem which I can't seem to find a solution for - I haveĬreated a set of financial reports for a client, which includes a number ofĬharts.
0 kommentar(er)
