Hi,

I'm using the REPT function to create in cell graphing which I found @
http://blogs.ittoolbox.com/bi/juicea...graphing-11035

My problem is that when I try to add a data label by concatenating the cell
value I don't get the percentage.

Is there a way of specifying that you want the percentage format dispayed as
a label in the graphing cell? or would it be best to calculate % in number
formatted cell?

This is the formula I'm using =IF($N14<0,N14&" "&REPT("|",-$N14*100),"")

Many thanks


--
Smudge