Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Abdulrehman Mohammed , Training and Development Manager - Technical , Almarai Company
Date Posted: 2013/09/30
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

=REPT("|",B2)

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

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

VALAN MARKS THANIS
by 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
by 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
by 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
by 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

Deleted user
by Deleted user

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

More Questions Like This