How show progress with graph bar with percentage input

[mrjackt]

Hi,
I would like to know how to input 10% 25% ect then in another cell the graph bar growing till 100% mark is completed.

Thanks in advanced

[sweep]

Hi,

A simple way to do this is as follows:

=REPT(CHAR(5),ROUNDUP(A1/5,1))

This generates a vertical line for every 5% in cell A1

[mrjackt]

I would like a color graph with percentage inside ?

[sweep]

That's available from XL2007 onwards. As far as I recall (I don't have 2003 installed on this machine) it's not available in 2003.

[mrjackt]

Thanks sweep, anyone else have 2010 xl that can help on this issue?

[sweep]

Your profile says Excel 2003 - if you have Excel 2010 then you can achieve what you need through conditional formatting.

Select the cell that will contain the % value

On the Home tab, select conditional formatting in the styles group.

Go to Data Bars > More Rules

Make both Type fields percentage, and set the minimum and maximum to 0 and 100 respectively.

Select the formatting you would like.

Click OK.

[mrjackt]

I guess i forgot to update my profile, my bad. Thanks for your assistance once again.