conditional format Graph Help

[Nabeel]

hello all
plz find attached.there is conditional format graph in column C & D..i want top of the each Bar percentage show...how i can do it
BR

 

[Somendra Misra]

Hi Nabeel,

In column C you have result of formula + CF and in column D you have result of a formula as a chart. You cannot have now numbers on them as there are formulas. The only thing that you can do in this setup is to apply data bar CF and un-check show data bar only option. SO it will display the %ages also.

Regards,

 

[Nabeel]

hi somendra
for column D ..what i need to do..
BR

 

[bobhc]

What you have are not true charts, you need to make true charts.

 

[Somendra Misra]

hi somendra
for column D ..what i need to do..
BR

Try using a formula something like below:

=REPT("|",(A1/2)*100)&TEXT(A1,"0%")&REPT("|",(A1/2)*100)

Well, personally I don't feel this is a good idea. Increase the font size so as to read the numbers.

Regards,

 

[Nabeel]

this is gud samendra..
but color of bar and value is same..can i put different..
BR

 

[Somendra Misra]

I think that's not possible through formulas.

Regards,

 

[Nabeel]

hmm thnx a lot.
BR