ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Abdulrehman Mohammed , Training and Development Manager - Technical , Almarai Company
تاريخ النشر: 2013/09/30
Zafar Iqbal
من قبل Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

=REPT("|",B2)

MUHAMMED HARIS MI
من قبل MUHAMMED HARIS MI , Senior Audit Staff , Saud Bahwan Group LLC.

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

VALAN MARKS THANIS
من قبل 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
من قبل 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
من قبل 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
من قبل 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

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

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟