Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Is it possible to do a in-cell chart in excel 2007?

user-image
Question ajoutée par Abdulrehman Mohammed , Training and Development Manager - Technical , Almarai Company
Date de publication: 2013/09/30
Zafar Iqbal
par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

=REPT("|",B2)

MUHAMMED HARIS MI
par MUHAMMED HARIS MI , Senior Audit Staff , Saud Bahwan Group LLC.

Yes it is possible,=REPT("|",B2)

VALAN MARKS THANIS
par VALAN MARKS THANIS , Accountant , Electric Home LLC

Yes. We can create by using REPT formula. We can type the numbers howmany times you want in another cell and we can use the formula.

Shahid Qureshi
par Shahid Qureshi , Assistant Manager - MIS / Financial Reporting / Agency Management in FRMU , Bank Alfalah Limted

Yes with the following principal

=Rept(text,number of time)

Mohamed Elabnody
par Mohamed Elabnody , IT & Foreign Purchase Manager , Egyptian Swedish co.

CREATE IN-CELL BAR CHART IN EXCEL2007 USING REPT FORMULA

 REPT

 

Enter formula in C2 

  =REPT("|",B2)

 

and drag it down

Reduce font size to7 and choose any colour and your chart is ready.

Abdulrehman Mohammed
par Abdulrehman Mohammed , Training and Development Manager - Technical , Almarai Company

Thank you very much, to add more to in-cell chart, change the font to PLAYBILL, this will condensed the lines and it looks more professional

Utilisateur supprimé
par Utilisateur supprimé

yes it is we can use conditional formating color scale or data scale, or by using th REPT function 

More Questions Like This