Excel - Old School Data Bars Using the REPT Formula in Excel - Dueling Excel - Episode 1369
1,826 views · Published 25 March 2011 · 3:19 · Indexed 16 November 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Using REPT function to create a bar chart in a cell in Excel. Welcome to another exciting episode of Dueling Excel! In this podcast, Bill Jelen from MrExcel and Mike Girvin from Excel is Fun are live at Highline Community College in scenic Des Moines, Washington. That's right, Washington! Did you know there's a Des Moines in Washington? Well, now you do! Join us as we explore the world of data bars and how they can make your data come to life. Data bars are like turning a histogram on its side, giving you a visual representation of your data. In this episode, Mike will show you how to use conditional formatting to create data bars, making it look like a cell chart. He'll also teach you a handy trick to quickly copy the formatting to other cells. And if you have Excel 2007 or newer, you'll get to see the cool gradient data bars that are available. But what if you don't have Excel 2007? Don't worry, Bill has a solution for you. He'll show you how to use the REPT function to create data bars. This function allows you to repeat a character or number a certain number of times, making it perfect for creating data bars. And if you're feeling adventurous, you can even use different characters, like asterisks or wingdings, to customize your data bars. So whether you're a fan of the newer data bars or prefer the classic REPT function, this episode has something for everyone. Join us as we have fun exploring the world of data bars and making our data more visually appealing. And don't forget to tune in next week for another exciting episode of Dueling Excel. Thanks for watching! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Creating Data Bars (01:24) Using REPT function (02:07) Scaling the REPT function (02:26) Alternative options (03:05) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Cell chart in Excel Conditional formatting Excel 2007 features Excel 97 features Excel data bars Gradient data bars in Excel Histogram in Excel Plain bars in Excel REPT function in Excel Solid fill in Excel Using wingdings in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153048/ Today's Dueling Excel Podcast, Episode #1369, Looks at creating Data Bars. in Excel 2010 and earlier versions of Excel. Check out today's Dueling Excel Podcast to learn about the =REPT Function to create a Data Bar set in an early version of Excel.
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920