Chart formatting and non breaking spaces

Hi all,

I'm having a problem and I cannot seem to find how to fix this anywhere on the web.

I have a stacked bar chart with my data labels showing down the x axis. My client wants me to put a bit of white space between the label and the actual chart. So I tried adding spaces to my data label but of course RS thinks they don't exist since they are not non breaking spaces.

How can I do the following in my chart label

=Fields!Myfield.Value & " "

As you can see I want to add a couple of spaces to my data label. I can't use  , all the ampersands get confused. I tried & char(32) but RS doesn't like char(n). I tried ChrW(160) [I saw this in the web somewhere] but this didn't work either.

Is there anything I can do?

thanks in advance, I'm at my wits end (again)

Annabel

Try Chr(160).|||thanks but this made no difference....We have told the client we can't add spaces between the label and the axis, they are ok with it.