I need to construct a data label in an excel chart using a formula building the string from two cells with a line break between them.
This would work in a cell formula:
=A1 & CHAR(10) & B1
and this would work in VBA
=A1 & Chr(10) & B1
as in this post: http://www.ozgrid.com/forum/showthread.php?t=40644 but neither of these approaches works inside a data label. Any ideas?