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

Here is a general method; if A1 contains:

the percentage is

and B1 contains
5%

then
=A1 & B1
displays
the percentage is 0.05

but
=A1 & TEXT(B1,"0%")
displays
the percentage is 5%

Using the TEXT() function allows you to capture the proper formats
--
Gary''s Student - gsnu200744


"Smudge" wrote:

> 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

Hi

Try
=IF($N14<0,TEXT(-N14/100,"0.0%")&" "&REPT("|",-$N14*100),"")


--
Regards
Roger Govier



"Smudge" <(E-Mail Removed)> wrote in message
news:0F73F5A0-F1FC-4BA3-8AAD-(E-Mail Removed)...
> 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

Thank you Gary :-)
--
Smudge


"Gary''s Student" wrote:

> Here is a general method; if A1 contains:
>
> the percentage is
>
> and B1 contains
> 5%
>
> then
> =A1 & B1
> displays
> the percentage is 0.05
>
> but
> =A1 & TEXT(B1,"0%")
> displays
> the percentage is 5%
>
> Using the TEXT() function allows you to capture the proper formats
> --
> Gary''s Student - gsnu200744
>
>
> "Smudge" wrote:
>
> > 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

Thank you Roger :-)
--
Smudge


"Roger Govier" wrote:

> Hi
>
> Try
> =IF($N14<0,TEXT(-N14/100,"0.0%")&" "&REPT("|",-$N14*100),"")
>
>
> --
> Regards
> Roger Govier
>
>
>
> "Smudge" <(E-Mail Removed)> wrote in message
> news:0F73F5A0-F1FC-4BA3-8AAD-(E-Mail Removed)...
> > 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
>
>
>